Add PowerBIIntegration.Refresh() for existing PowerApps

[jvanrossum]

PowerBIIntegration.Refresh() is now available for new PowerApps to refresh the Power BI dataset, but this doesn't work for existing PowerApps. Please add a 'refresh' option to refresh the methods of PowerBIIntegration.

PowerBIIntegration.png

[lav]

PowerBIintegration funtion s not coming in powerapp reports.

Please explain to me why its not coming in my powerapps reports.

[jvanrossum]

Hi lav,

It's a functionality dat Microsoft only adds for new PowerApps. The functionallity cannot be added to existing PowerApps. That is a pity if you already have a bunch of exiting PowerApps that are connecting to Power BI data.

Regards,

Joost

[tahiralvi]

Hi,

Scenario: updating the database from PowerApps form and call PowerBIIntegration.Refresh() update my data in the database (confirmed with query).

But the Power BI visuals are not updated simultaneously ( am using DirectQuery for Azure Sql Server).

Specification: Using Power BI Pro (Trail Version).

Question: Is refresh Power BI only available in paid version not in pro ?

[jvanrossum]

> Question: Is refresh Power BI only available in paid version not in pro ?

It's a standard feature. I tested it with an Office 365 Subscription for Power Apps and a Pro licence for Power BI.

[lakVenkat]

Created a new APP in Sep 2019. Still PowerBIIntegration.Refresh(); is showing the error when I try to add after update the database table. 

---

@jvanrossum wrote:

PowerBIIntegration.Refresh() is now available for new PowerApps to refresh the Power BI dataset, but this doesn't work for existing PowerApps. Please add a 'refresh' option to refresh the methods of PowerBIIntegration.

---

[senpaicoder]

Hi,

I can confirm the very same scenario - which lakVenkat mentioned earlier- happened to me this morning (October 6, 2019). I must also point out that - like lakVenkat - I didn't use any existing app, but created a brand new blank Form "all from scratch" which I could later integrate in Power BI report to grab user data inputs. Power BI Desktop content is connected to very same PowerApps Azure SQL Server defined database in DirectQuery mode. Adding PowerBIIntegration.Refresh(); in PowerApps code doesn't seem to be supported at this stage and displays same unknown or unsupported function error. (sigh...). Any updated information would be appreciated. Thank you.