Hi Team , I'm new here in Power BI how to import excel file into Power BI Desktop.
may i ask few quetions : *How we import Excel File in Sharepoint to Power BI ? I tried multiple ways with Link , but it doesn't work , it always failed and can't find the right excel document.
*Can Excel File in this sharepoint can be connected and well refreshed in power BI ? means , whether we only need to connect to the internet to refresh the data and publish. it doesn't have any impact to the source of data ?
Hope to receive your random response very soon.
Thanks with Best Regards,
You can connect to the Excel via below methods:
a. Use SharePoint Folder data source, and enter the SharePoint site URL.
b. Open the Excel via Excel desktop, and get URL via File -> Info. Use Web data source, enter the URL with ?web=1 removed. See: https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links
After publish the report to Power BI service, if the Excel contains external data source, you might need to configure the gateway, see: https://docs.microsoft.com/en-us/power-bi/refresh-excel-file-onedrive
Hi Dear @v-qiuyu-msft
I had been tried multiple ways , that my data had been failed to refresh , i'm not sure because our data Data Cridential Source ?
I tried Anonymous , Window , OAuth , still failed.
this is my first experiment with Sharepoint.
Please choose OAuth2 authentication and then you should be able to sign in your Sharepoint account. Please clear browser cache and restart browser to test again.
If issue persists, please click the Show Details and share the screenshot again.