Forum Discussion
Power Query not loading required files
Hi,
My power query not loading the required file into my power bi desktop. I listed the step I followed to load the file from share folder. However, the desktop is working perfectly when I'm using the data source which stored in my local drive.
- Follwing URL is the connection to my share folder.
- Actually my sharefolder contains two folders. I require only highlighted folder for my working.
- So the URL shows all the files when I transform into power query. Despite that I need only highlighted file for my working. So, I filtered only required file.
- When I close & apply.
- After closing it. What it’s showing in query1 are, not what I expected. Despite all, It’s working perfectly on my local drive, So there couldn’t be error with a file format.
Please support to rectify the issue.
4 Replies
Hi Anonymous
Click on "view error" to see details.
Or go to edit queries, see if there is any "Query errors" under the left queries pane.
Share details for further analysis.
You could also check if there is any column where some rows have incorrect data type/format.
Best Regards
Maggie
The 'View Error' shows as per the below image. On 'Kept Errors' it shows the This table is empty. However, According to source, my file 'Consolidated Sales Report 2019' contains the table name 'SalesReport_2019'.
Apart from that, I re-enter my credentials as well in 'Data source settings'.
Thanks
Shiham
Hi Anonymous
You could check if the following provides any useful solution.
https://community.powerbi.com/t5/Desktop/Blank-Table-error/td-p/297329
Best Regards
Maggie
