Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hi, I have an issue with a report, it was built using Excel workbooks as data sources, located in a shared drive, the excel sheets get updated automatically, and Power Bi pulls that data, the report runs fine and refresh in Power BI desktop works good, but when publishing it to Power BI service I don't see the gateway selection, all i see is:
This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources.
I've seen and read many blogs and I couldn't fnd anything related to shared drive location post with the same error.
any help will be appriciated.
thank you
Solved! Go to Solution.
Hi @bro10
It looks like you will have to change your datset a bit so you can access the network path using on-premises gateway.
Please go through below link which will give you an idea:
Let me know if you need more info on this.
Hi, I got it to work: some of the data source were using web.content(), changed them to File.content() and it's working good, thanks for pointing me to right direction.
Hi @bro10
It looks like you will have to change your datset a bit so you can access the network path using on-premises gateway.
Please go through below link which will give you an idea:
Let me know if you need more info on this.
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 15 | |
| 10 | |
| 10 | |
| 8 | |
| 7 |
| User | Count |
|---|---|
| 41 | |
| 37 | |
| 35 | |
| 29 | |
| 20 |