Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
Hi @Anonymous,
Please restart your gateway and check if it works fine.
Best Regards,
Angelia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.