cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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
Highlighted
Community Support
Community Support

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
Highlighted
Community Support
Community Support

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

Highlighted
Regular Visitor

Re: Reset Power BI filters after PowerApps update

Ok, thanks for this explanation.

 

I hope to see this upgrade valable soon

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,036)