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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
87 | |
74 | |
67 |
User | Count |
---|---|
124 | |
112 | |
98 | |
81 | |
72 |