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

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.

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
Post Prodigy
Post Prodigy

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.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.