Forum Discussion
Helper IIData On-Premises Vs. SharePoint Online
Tara_ I would recommend you to keep the excel files in SharePoint online. So that we can avoid the dependency with Gateway.
You have to use the SharePoint Folder connector for getting the excel files into Power BI.
You can connect SharePoint online directly with Power BI desktop. If needed, you can use dataflow as well.
Also, you can schedule the daily/weekly data refresh. or you can use Microsoft Power Automate to trigger the data refresh after a new file added to the SharePoint.https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Helper IIThank you for your repsonse. I have a couple of follow up questions.
1. I was planning on using the web connector to individually connect to each excel file in sharepoint online. Not sure if I will receive both at the same time. Would performance differ in this case from using the Sharepoint folder connector?
2. The link was very helpful. It did mention though that "Power BI’s existing fixed refresh schedules are not sufficient to accomplish this" , why not? and does this mean it is not generally used? As far as I know using Power Automate will require extra licensing. I will test it nevertheless but I wonder if you have used the existing fixed refresh option before.
Thanks
Community ChampionYou can use Web connectors as well. (Had noticed some connection issues before).
But better option would be SharePoint folder connector.
Also default scheduled refresh is enough. I just highlighted another option. Ofcourse, additional licence required for Power Automate.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
- nandukrishnavs
Tara_
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂