Sharepoint excel to enterprise gateway data source

[Anonymous]

Dear All!

I have 3 excel files in Sharepoint, and I'd like to get these files into the enterprise gateway's data source, but I can't do this, cause I don't know which data source type and path to give in this case!

Please help me!
Thanks for your reply!

Máté Kiss

[v-huizhn-msft]

Hi @Anonymous,

After research, if you get date->file-> Sharepoint Teamsites in Power BI service, you don't need a gateway. 



In your scenario, you get data in Power BI desktop, then publish it to service? For more details about getting data from excel stored in Sharepoint, please review the following articles.

Loading Excel Files from Sharepoint
Combining Excel Files hosted on a SharePoint folder with Power BI

Best Regards,
Angelia

[Anonymous]

Dear @v-huizhn-msft!

The truth is that, I have three excel files in Sharepoint, and two web source in Power BI Desktop. Than I published it to Power BI Service, and I connected it to an enterprise gateway. But it seems these sources don't like this connection, because it seems that the gateway is offline. But I checked it and it's working and online! So I don't know what's the problem and how to solve it!

Thanks for your help!

Best Regards,

Máté Kiss

[v-huizhn-msft]

Hi @Anonymous,

Please restart your gateway and check if it works fine.

Best Regards,
Angelia