Unanswered

Refreshing Power BI Visuals from Power Apps Using PowerBIIntegration.Refresh(), Not Working

(0) Share

Report

Posted on by ginowms0405

Hello,

I have a Power BI report with a Power Apps interface embedded in it. The source to the Power BI report is a SQL Server table that is set up as Direct Query. While developing the report in Pro mode, everything worked perfectly. I was able to execute an update to the SQL Server table via Power Apps and have the Power BI visuals refresh automatically. However, when I had to up the licensing to Premium Per Use for access to the Power Apps interface -- because of a SQL Server connection, which is premium -- the refresh to the visual no longer work. The data gets updated and I can refresh the entire screen manually to force the visuals to refresh. However, it appears that the PowerBIIntegration.Refresh() function doesn't do that automatically. I notice the screen flickers as if a refresh happens, but nothing.

Has anyone else encountered this kind of scenario? I am finding that the mix of licensing between Power BI and Power Apps is forcing me into administration mode more than development.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @ginowms0405,

Could you please tell me that if you use the Power Apps visual for Power BI?

If so , I think there is something limit you should know about this:

The Power Apps visual can't trigger a refresh of Power BI reports and Power BI data sources from within Power BI Desktop. If you write back data from the app to the same data source as the report, your changes won't be reflected immediately in Power BI Desktop. Changes are reflected on the next scheduled refresh.

Following limitations apply when using the PowerBIIntegration.Refresh() function:

You must create a new app from Power Apps visual in Power BI report for this function to be available in the app.

You must use a source that supports DirectQuery and the data connection must be created using DirectQuery method.

Was this reply helpful? Yes No
Verified answer

ginowms0405 19 on at

Like (2)

Report

Hello,
I created the PowerApps interface within Power BI in Power BI services. A lot of the readings I've come across recommend using Power BI services to embed Power Apps instead of Power BI desktop.

The PowerBIIntegration.Refresh() function gets created, as expected. And because the source table to the Power BI visuals are set up as DirectQuery, the visuals indeed get refreshed when I click the "Refresh visuals" icon. I noticed the visuals will also get refreshed if I click the Save button in Power Apps a second time.

I just did a full flush of my cache and now I get the proper outcome. Looks like I need to clear my browser, close it, and go back in. I was not expecting that. Thanks for the response, though.

Was this reply helpful? Yes No