I'm currently having problems connecting to a sharepoint site using the Sharepoint.Contents command and ApiVersion 14.
PowerBI doesn't return any folders or files to connect to, although there are folders in the site and files in these folders.
The query window is simply empty.
Can anyone help me with this?
I doubt it. If the credentials are wrong, you probably would get an error. But do you have access to the doc library with your credentials?
It's hard to say given you have blacked out the URL in the image. You could try clearing the credentials in Power Query. If they are right and the URL is right, I can't see any reason why it won't work.
You need to connect to the root site first. Something like
I already connected to the root-site in the code, but it only returns an empty table.
Could the problem perhaps be due to missing credentials in sharepoint?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.