Solved: Cannot access data from ADL Gen2

Anonymous · ‎08-18-2020

Hi All,

I tried accessing the data from a .txt file store in ADL Gen2 , when i connected successfully all it is showing me is the information of the file and not the actual data in the files. Please need help.

Anonymous · ‎08-19-2020

Thanks Everyone. Issue resolved. I clicked on the query and clicked on binary and was able to get the original data.

View solution in original post

v-kelly-msft · ‎08-19-2020

Hi @Anonymous ，

Check the reference below:

https://www.sqlbi.com/blog/marco/2020/05/29/optimizing-access-to-azure-data-lake-storage-adls-gen-2-in-power-query/

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Anonymous · ‎08-19-2020

Thanks Everyone. Issue resolved. I clicked on the query and clicked on binary and was able to get the original data.

Anonymous · ‎08-18-2020

Hi @Anonymous

How is your delimited might be the source of your issue.

As for csv it is delimited by ",". But you are using a text file.

Please check.

Anonymous · ‎08-18-2020

i canged the source file as .csv instead of .txt and it is still the same.

Anonymous · ‎08-18-2020

So what is the solution change it to .csv type?

parry2k · ‎08-18-2020

@Anonymous how are you connecting to the file on ADLS Gen2? Are you using direct link to the file or what? Can you share M script by clicking advanced editor.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.