cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kissmate Regular Visitor
Regular Visitor

Sharepoint excel to enterprise gateway data source

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

3 REPLIES 3
Highlighted
v-huizhn-msft Super Contributor
Super Contributor

Re: Sharepoint excel to enterprise gateway data source

Hi @kissmate,

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

1.PNG

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

kissmate Regular Visitor
Regular Visitor

Re: Sharepoint excel to enterprise gateway data source

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 Super Contributor
Super Contributor

Re: Sharepoint excel to enterprise gateway data source

Hi @kissmate,

Please restart your gateway and check if it works fine.

Best Regards,
Angelia