cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Imported Excel from Sharepoint 365

 

1.PNG

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, 
Chanleakna Hang 

5 REPLIES 5
Moderator v-qiuyu-msft
Moderator

Re: Imported Excel from Sharepoint 365

Hi @Chanleakna123,

 

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

 

Best Regards,
Qiuyun Yu 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Imported Excel from Sharepoint 365

1.PNG

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. 

Thanks 

Moderator v-qiuyu-msft
Moderator

Re: Imported Excel from Sharepoint 365

Hi @Chanleakna123,

 

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. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Imported Excel from Sharepoint 365

1.PNG

Hi , the message shown above. i have no idea what's wrong with this. 
Any solution on this part ? 

 

thanks with Regards, 

Leakna 

Highlighted

Re: Imported Excel from Sharepoint 365

@v-qiuyu-msft hi , any update on this case ?