get data from .txt files on sharepoint

[wynhodgkiss]

Hi,

I have a number of .txt files stored in separate sharepoint folders. Any ideas as to why I can connect to these using PowerQuery in excel but not using PowerQuery in Power BI?

When using PowerQuery in excel, I can connect to the sharepoint folder and filter to the specific file and when I expand the content I can then select the File Origin to get the correct encoding (UTF-8) and my data is then presented in a single column ready to be split.

When using PowerQuery in Power BI Desktop, I can connect to the sharepoint folder and filter to the specific file but when I attempt to expand the content I get the below error message:

My Excel version is 

Microsoft® Excel® for Microsoft 365 MSO (Version 2210 Build 16.0.15726.20188) 64-bit

My PowerBI Desktop version is: 2.110.1161.0 64-bit (October 2022)

thanks

[JoaoMarcelino]

@wynhodgkiss I'm happy to know it is fixed, I'm glad to help 🙂

[JoaoMarcelino · Accepted solution]

Hi @wynhodgkiss  🙂

From my understanding, you can:

• Connect to sharepoint; 
• Filter folder you want to get; 
• Filter the file you wish to expand;
• When you choose "Binary" in the "Content" column, this is the resulting code, with the encoding in the end:
  

Are these the corresponding steps that you've followed and your Power Query writes?

If not, consider running these steps and adjust the code in accordance 🙂

Hope I was of assistance!
Cheers
Joao Marcelino

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

[wynhodgkiss]

Thanks @JoaoMarcelino . When I tried to connect to the same sharepoint folder via power bi today it works.