Forum Discussion
Solution for Power BI reports using Sharepoint list as data source?
- Anonymous5 years ago
I kinda of answered my own question on the post and didn't realized it.
I'll just explain it all if anyone ever has this same issue again:
Sharepoint is kind of an online database so it's all in the cloud, when you use Power BI Desktop you'll need to login with the same account you have permission to that sharepoint list, so it'll be able to authenticate and get all the info you need.
However, it's not that simple when your report is published online. In a Report Server you can upload a report but it won't ever be able to refresh and autocollect the data again once it's there, you'd have to re-upload the .pbix with the data already on it.
The work around I've found for my company was to create a flow using Power Automate and the on-premises gateway. The way it works is that periodically (in my settings it's once per day) it will fetch all the lists I want that are on the cloud and place it in a folder of my company intranet. This way I've modeled the B.I to gather data from those local networks instead of the online sharepoint list, and once it's in the Report Server it'll work just as fine.
I hope it could be usefull for someone. Cheers.
Hi Anonymous ,
Would you please mark your reply as answer?
Thank you for your sharing.
Best Regards,
Dedmon Dai