Forum Discussion
Connecting to SharePoint Folder error
I eventually found a work around to the issue which works but isn't ideal.
I had to do the following (hopefully this helps others with the same issue).
1. Connect using SharePoint List to any list within the correct site. (using Windows credentials)
2. In query editor manually change the source code
from this:
= SharePoint.Tables("https://isharenew.company.com/sites/example_site", [ApiVersion = 15])
to this (red text):
= SharePoint.Contents("https://isharenew.company.com/sites/example_site", [ApiVersion = 14])
Then I just renamed the source from the original SharePoint list name I randomly selected in step 1 above to whatever I want it to be eg "SharePoint_Folder_1_Source"
If anyone could explain why I needed to do this work around that would be great because I would rather not have to do it!!
Hi moomarine ,
Would you please try to create a new pbix file and clear the Permission the data source of SharePoint you used before under Edit Queries>> Data source setting>>Global Permissions>> find the sharepoint source >> Clear Permissions.
And please refer to the similar thread: https://community.powerbi.com/t5/Desktop/Sharepoint-Folder/td-p/237546
Best Regards,
Dedmon Dai
I eventually found a work around to the issue which works but isn't ideal.
I had to do the following (hopefully this helps others with the same issue).
1. Connect using SharePoint List to any list within the correct site. (using Windows credentials)
2. In query editor manually change the source code
from this:
= SharePoint.Tables("https://isharenew.company.com/sites/example_site", [ApiVersion = 15])
to this (red text):
= SharePoint.Contents("https://isharenew.company.com/sites/example_site", [ApiVersion = 14])
Then I just renamed the source from the original SharePoint list name I randomly selected in step 1 above to whatever I want it to be eg "SharePoint_Folder_1_Source"
If anyone could explain why I needed to do this work around that would be great because I would rather not have to do it!!
Hi,
I had something similar.
I was getting the information through, but then at every refresh I would get the notification of an error. Then the error table was empty.
Inspired by your solution, I simply changed the ApiVersion from 15 to 14, using the "Advanced Editor" and it now works without error.
It might be some bug in the API, not sure how to flag it, since there is no error code, only the fact that an error occurred.