Forum Discussion
i_stanescu_ro
Helper I
Helper IAuto Update report in PowerBI Service, after changes are made in excel Sharepoint
Hi guys I have a PBI report and the source of data is an excel in Sahrepoint, I used "web" to fetch the data. The source has changes made weekly, and I would need these changes to be seen in PBI...
Hi. Well, it's tricky. Depending on the license you have you might have different alternativas. Considering most people have Pro licenses. The pro has a limitation of 8 automatic refreshes per day. So if you are refreshing the dataset for each changes you make in the day, it might hit a limitation really fast and keep you with the manual way all over again. (That would be done with Power Automate.)
I would probably configure 8 refresh a day during working hours.
I hope that helps,
lbendlin
Super User
Super UserI used "web" to fetch the data.Don't do that. Use the Sharepoint Folder connector.
i_stanescu_roHelper I
Helper IWill do that for sure! Thanks so much!