Connecting to Blob Storage with a Shared Access Signature in Power BI

[AnkitSingla]

I am trying to access Azure blob storage using SAS keys and following the link below :

Connecting to Blob Storage with a Shared Access Signature in Power BI | Microsoft Docs

On Step 8 Click the "Drill Down" button to expand the binary files, i am facing below error :

I am having 2 csv files only. Still facing above error.

Any idea?

[v-cazheng-msft]

Hi @AnkitSingla 

Have you ever tried the operations in Part 3 and switch the parser to open the file as a “CSV Document”? If it doesn't work, it maybe some issue in the CSV files. Sometimes that error occurs when a file is the result of exporting from a third-party program. These files can have a minor errors in XML schema and  Power Query will fail to identify data because of  this error. You can try to  open it in Excel, save and close.

Best Regards

Caiyun Zheng

If this post helps, please consider make it as the solution by Accept it as Solution. Really appreciate!