cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FredLEGUEN
Level: Powered On

Reset Power BI filters after PowerApps update

Hi the group,

 

I have created a Power BI dashboard with many tables to visualize the tracking of goods.

The more you apply filters and the less you have have goods visible (that's logic).

 

Once the user has selected the number of item he wants, I have create a PowerApps canvas to update the database with comments and remarks. Like that, the apps can update the status for one or more goods.

 

So everything works but I would like to refresh my Power BI report after the update. Because when the update is done, only the last filter (the one updated) is still visible.

Not really professional.

 

Any clue to solve this ?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Reset Power BI filters after PowerApps update

Hi @FredLEGUEN ,

Do you want to refresh your Power BI report when then changes (e.g. Comments, remarks) made to your data source through the embedded canvas app?

Further, do you add a PowerApps Custom Visual within your Power BI report?

 

Currently, there are some known limits with the PowerApps Custom Visual in Power BI report. The PowerApps custom visual can't trigger a refresh of the Power BI report or Power BI data source. If you write back data from the app to the same data source as the report, your changes won't be reflected immediately. Changes are reflected on the next scheduled refresh.

In other words, the refresh of your Power BI report is based on the Schedule refresh setting you specified in your Power BI data set.

 

More details about the known limits with PowerApps Custom visual in Power BI, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual#limitations-of-...

 

As an alternative solution, you could configure the Schedule refresh for your dataset in your Power BI in a low frequency or turn on the "OneDrive refresh" option to make your dateset keep up to date. You could also consider refresh your Power BI report manually.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Reset Power BI filters after PowerApps update

Hi @FredLEGUEN ,

Do you want to refresh your Power BI report when then changes (e.g. Comments, remarks) made to your data source through the embedded canvas app?

Further, do you add a PowerApps Custom Visual within your Power BI report?

 

Currently, there are some known limits with the PowerApps Custom Visual in Power BI report. The PowerApps custom visual can't trigger a refresh of the Power BI report or Power BI data source. If you write back data from the app to the same data source as the report, your changes won't be reflected immediately. Changes are reflected on the next scheduled refresh.

In other words, the refresh of your Power BI report is based on the Schedule refresh setting you specified in your Power BI data set.

 

More details about the known limits with PowerApps Custom visual in Power BI, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual#limitations-of-...

 

As an alternative solution, you could configure the Schedule refresh for your dataset in your Power BI in a low frequency or turn on the "OneDrive refresh" option to make your dateset keep up to date. You could also consider refresh your Power BI report manually.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

FredLEGUEN
Level: Powered On

Re: Reset Power BI filters after PowerApps update

Ok, thanks for this explanation.

 

I hope to see this upgrade valable soon

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,102)