Auto refresh Power BI Controls inside Power Apps

[@sureshsuthar6118]

Hi Daniel, I am able to refresh only 8 times per day, Are there any additional settings that need to be applied?

[@DanielChristian19]

Hi Suresh, With Power BI Pro, you are allocated 8 refreshes a day, with premium you can do 48.

[@eirikandersen9848]

Hi Daniel! I am trying to use Power Apps in Power BI, but the power apps visual keeps refreshing when I change report pages. Do you have any workarounds for this?

[@DanielChristian19]

You could change the setting of that Power Apps visual to not refresh.

[@rchong3289]

This is great ! Thanks. Two things wish to get some answers: (1) So does the max 8 times refresh per day still apply under this method ? (2) Do you know if we can do the same but in PBI with powerapp inside PBI report to do CRUD then refresh the PBI report in PBI service ?

[@DanielChristian19]

Hey R Chong, 1) The max 8 times does not apply here. You can refresh as many times as you need. 2) Yes, you can as long as your app has the Power BI Integration connection in it.

[@caynaferraz8080]

@@DanielChristian19 i have tried this method but i can only refresh 8 times a day or 48 using premium. I have a excel that is in sharepoint and connected to my powerapps and powerbi. How can i make them refresh many times as i want? Thank you in advance

[@zero2herobeatspaul882]

Awesome, Daniel. I will look through your videos for information on dynamically filtering the tile. That’s my next challenge.

[@DanielChristian19]

Glad it was helpful!

[@juansepowerplatform]

Hello thanks for the video. Will this work if you embed a report and not a dashboard? if your report is built in top of a dataset that takes 10 minutes to refresh then by default the embedded report will take the same to refresh

[@DanielChristian19]

Hey Juan, Your welcome. No, it will not work. You have to use the Power BI control and select the dashboard and title to make it work.

[@ntk1348]

Hi Daniel, Is it possible to pass parameters to the PowerBI visual. e.g, I want the report to be filtered based on who is using the App (i.e based on the user who is logged-in)? Also, is there any documentation or blog on this new PowerBI connector? Thanks a lot.

[@DanielChristian19]

Yes, absolutely. You can use the user() function to get the login user info and add it to the URL filter. Here is the doc for it. docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

[@dannipals79]

Hi great video. Does this work with Azure - SQL database ?

[@DanielChristian19]

Yes it does.

[@sushichow]

But it's such a bummer that how many refreshes are dependent on the lisence we have. For pro I think it's 4 or 5 .

[@DanielChristian19]

Hey Susheel, This auto fresh is not limited to 8 times for Pro or 48 times for premium licenses. You can refresh it countless number of times.

[@sushichow]

Oh, but when I used refresh data set in power automate which was being triggered through powerapps on a button click, gave me error regarding the limit. I hope then it is limited to power automate 🤔🤔🤔🤔

[@bhainsley]

Wow! Did. Not. Know. This. Thanks, Daniel. This is indeed a huge game changer for PBI/Power Apps integrations.

[@DanielChristian19]

Yup, I agree Billson. This is big!

[@filipwinski4219]

Hello, Great Video!!! Some questions: 1. Does it work with Share Point lists? 2. Does it work, in PowerApps for Teams with Teams Dataverse (I didn't find there information about environment URS and Data Base Version)? 3. Does it work when there is an import mode from PowerApps to PowerBI (There was direct query mode on your PBI)?

[@DanielChristian19]

Hi Filip, It will not work with SharePoint lists because we cannot make a Direct Query access to Power BI. Import mode does not work either. This will work with Teams Dataverse as long as you have the settings configured

[@filipwinski4219]

@@DanielChristian19 Thank you for your response. MS Power Platform is great, but unfotunatelly refreshing data across the tools is not properly addresed. When you compare how it works for example in case of Google Data Studio and Google Sheets, where you've got updated data immidiately after clicking refresh button, it is clear that MS has here some work to do.

[@CybersniperKiller]

Hi Daniel, This is Santhosh, I have an Implemented same in my project but, the user requirements are after clicking a button the dataset should get refreshed successfully. But user doesn't know it is completed or not or whether it is in progress or not. So, how we can implement that "Status" inside the power apps or can we do something. If you have time could you please make a video for that and eagerly I am waiting for that video. Thanks, Santhosh.

[@RachelGoodman-ly9td]

awesome thanks so much - i had to use the workspace id and data set id to get mine to work :)

[@jandos88]

great job. Thats what I was looking for

[@DanielChristian19]

Glad I could help

[@sundrapillay6668]

Thanks Daniel

[@DanielChristian19]

Thanks for the support, Sundra

[@user-qo2ey1cy6b]

Great video

[@DanielChristian19]

Glad you enjoyed it

[@user-qo2ey1cy6b]

@@DanielChristian19 Thanks

[@cheltonnunes7921]

Great video, i must subscribe.

[@DanielChristian19]

Welcome aboard!

[@charlessterling379]

Very cool Demo!

[@DanielChristian19]

Hey Chuck! What an honor to have you compliment on my video 😀. The Power BI connector is going to make the integration with Power Apps Canvas so much easier.

[@kishorec1117]

Thts so cool for dynamic update and user inputs (Y)

[@DanielChristian19]

Yes it is!