Hi Team - I have a Power BI dashboard that allows users to edit specific fields within a table chart. To enable this functionality, I implemented a Power Apps solution and integrated it into Power BI. However, the PowerBIIntegration.Refresh() function does not consistently refresh the visuals in the report. Sometimes it works as expected, but other times it does not.
Implementation
1) Fabric SQL Database: Contains the table with the columns to be edited.
2) Fabric Lakehouse (SQL Analytics Endpoint):
2.1) A data model was created using the Lakehouse SQL Analytics Endpoint.
2.2) A shortcut was created to the Fabric SQL Database.
2.3) The shortcut table was included in the data model.
Note: Changes made in the Fabric SQL Database take 25–30 seconds to reflect in the shortcut.
Edit Form Code:
SubmitForm(EditForm1);PowerBIIntegration.Refresh();
Flow:
A row is selected in the table chart.
Corresponding data is displayed in Power Apps (using a Power Apps Form and Azure SQL as source).
2.1 Row is selected in tabled chart and Fields are edited in Power Apps.
2.2 Save button is clicked.
2.3 Power BI refresh visual is triggered
Issue: This refresh is inconsistent—it sometimes works, but other times it does not.
Can you please suggest if there are any workarounds?
Thanks,
Abhiram
Share
Report
All responses (
Answers (
796
