Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Amz_123
Helper I
Helper I

Power BI service refresh error with SharePoint Connection

Hi community,
Please guide me in resolving Share Point Connection Error.

1. I have connected .csv source file from Share Point to Power BI. On refreshing the pbix Desktop file, my dashboard is refreshing without any error.
2. I have published my .pbix file to Service and configured scheduled refresh. On applying Manual refresh and also at scheduled refresh timing, I am receiving error. Below is the screenshot of my error message.
1.png

I couldn't predict the reason for this issue. Everything is fine in PBIX Desktop but when same file is published in Power BI Service, I am receiving error.

3. Is there any way to apply timeout command in M-Script

Source = SharePoint.Files("https://s2019.sharepoint.com/sites/a/", [ApiVersion = 15]),
#"sample csv_https://s2019 sharepoint com/sites/a/b/" = Source{[Name="sample.csv",#"Folder Path"="https://s2019.sharepoint.com/sites/a/b/"]}[Content],
#"Imported CSV" = Csv.Document(#"sample csv_https://s2019 sharepoint com/sites/a/b/",[Delimiter="#(tab)", Columns=16, Encoding=65001, QuoteStyle=QuoteStyle.None]),

Please assist me in resolving this issue.

Any assistance is appreciated.
Thanks in advance,
Amz.

2 REPLIES 2
rajendraongole1
Super User
Super User

Try to configure data source credentials with sharepoint link that you want to connect and give the authentication method with  oAuth2 method and give the set privacy level to organ.

 

I hope it works. Try and let know.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Unexpectedly it did not work. Manual Refresh is fine in pbix desktop. I have set authentication method as "oAuth2" and privacy level to "organization". Still the issue persists in Power BI Service. What does an existing connection is forcibly closed by remote host mean. 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.