Forum Discussion
Sharepoint gateway
Power BI typically doesn’t need a gateway for SharePoint Online files. But if your data model mixes SharePoint with any on-premises or unsupported data sources, the service will demand a gateway for refresh even if your main source is cloud-based.
For possible troubleshooting steps you could check the following and let us know if it helps :
- Double-check if your model used only cloud data sources (just SharePoint, no on-prem or personal/local files).
- In the dataset settings within Power BI Service, went to “Data source credentials” and re-authenticated with your Microsoft account for SharePoint.
- Look for the “cloud connection” option this should be selectable if only cloud sources are detected.
- If that still didn’t solve it, republished the report from Power BI Desktop to a new workspace as a clean test, then set up credentials again.
Also, If there is any recently updated tenant policies, this might affect how connections are managed. In this case, asking your Power BI admin to review settings can help.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
Power BI typically doesn’t need a gateway for SharePoint Online files. But if your data model mixes SharePoint with any on-premises or unsupported data sources, the service will demand a gateway for refresh even if your main source is cloud-based.
For possible troubleshooting steps you could check the following and let us know if it helps :
- Double-check if your model used only cloud data sources (just SharePoint, no on-prem or personal/local files).
- In the dataset settings within Power BI Service, went to “Data source credentials” and re-authenticated with your Microsoft account for SharePoint.
- Look for the “cloud connection” option this should be selectable if only cloud sources are detected.
- If that still didn’t solve it, republished the report from Power BI Desktop to a new workspace as a clean test, then set up credentials again.
Also, If there is any recently updated tenant policies, this might affect how connections are managed. In this case, asking your Power BI admin to review settings can help.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
I couldn’t solve the issue, so I deleted everything I had published and all the connections I had created. I reconfigured the data sources I had set up in the report, republished it, and I was finally able to connect the SharePoint file. The problem probably wasn’t caused by the file in SharePoint, but by something else I had misconfigured.
thank you so much 🙂