Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
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.
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.
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 37 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 130 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |