Forum Discussion
Refreshing Dataset-->Report
So, I am very new to Power BI and Power Automate, as of last week. My setup: Workspace with Premium. I get this error when trying to connect to my Sharepoint file in Power BI, Get Data from...
This won't work. I can't use the short address as you mentioned, it only gives me a list of files, not a directory to choose from.
If I copy the link to the exact xls file, I get this:
If I try to connect to folder that contains the above xls file, I get this:
If I use the From Web source and use the copied link for the xls file, I get this.
The purpose of the sharepoint conection is to conecto to a sharepoint folder, and the in powerquery, you filter the files you want to work with.
You can filter through the Folder Path Field.
Check this video: