Re: Power Query not loading required files

Anonymous · ‎04-01-2020

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.

watkinnc · ‎04-07-2020

Hey there. You can’t just select the row that contains the files, you have to then select the file itself. Just click on the two arrows icon above the Binary table—good to go!
By the way, XLSB files don’t always play nice with Power Query...

I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

v-juanli-msft · ‎04-01-2020

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

Anonymous · ‎04-02-2020

Hi @v-juanli-msft

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'.