Forum Discussion
Refresh the Sharepoint Excel file Dataset in Power BI Service
Hi, I use an Excel file in Sharepoint as datsource to my Dashboard. In Power Bi Desktop , I use the 'Web' option of datasource to connect this file and provide the Sharepoint URL until the path ...
Hi Gilbert,
No, I dont have a Personal gateway setup.
Thanks
Svee
GilbertQ
Super User
Super UserHi there
I just had a look at one of my connections and it appears that you should not need the gateway when connecting to an Excel file stored in SharePoint online.
If you can confirm that your SharePoint is either SharePoint Online or OneDrive for Business?
I just had a look at one of my connections and it appears that you should not need the gateway when connecting to an Excel file stored in SharePoint online.
If you can confirm that your SharePoint is either SharePoint Online or OneDrive for Business?
Hi Gilbert,
It is Sharepoint Online, but when I access it Power BI Dekstop, I'm selecting the Datasource type as 'WEB'.
Is that creating the issue?
Thanks
SVee
- GilbertQHi there
That should be fine, just make sure that it is using the SharePoint.com in the URL?Hi Gilbert,
Yes it uses https://____ .sharepoint.com.................. in the beginning of the URL.
Thanks
SVee