Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sharepoint Data Source file Invalid Credentials in Service

I have created a power BI report that has two data sources (SQL On-premise via Gateway and a Sharepoint file in O365).   I can connect to and view both data sources without issue in desktop but aft...
Need Help
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

In your scenario, to connect to Excel that is located under Documents of SharePoint online site, please use the URL below.

https://xxxxx.sharepoint.com/sites/<sitename>/Shared%20Documents/<Yourexcename>.xlsx

 

To connect to Excel that is located under a folder in SharePoint online Documents, please use the URL below.

https://xxxxx.sharepoint.com/sites/<sitename>/Shared%20Documents/<Foldername>/<Yourexcename>.xlsx

 

Then in the upper-right corner of the Power BI service, go to the gear icon  ->Manage gateways., tick on the option "Allow user's cloud data sources to refresh through this gateway cluster" like below, click "Apply". You can learn more: https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud.

 

 

 

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.