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

Like (0) Share

Report

Posted on 15 Jul 2022 14:48:19 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:

General Questions

Connectors

All responses (2)

Answers (1)

Verified answer

ginowms0405 19 on 18 Jul 2022 at 13:54:56

Like (2)

Report

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

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.
v-qiaqi@microsoft.com on 18 Jul 2022 at 03:45:59

Like (0)

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

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.