Connecting share point folder to power bi & Transform file and helper queries

[Anonymous]

Hello everyone,

I am connecting my power bi to a share folder and feteching all the data from the folder for this operation is creating a group (Transform file) & Sub Group (Helper Queries) and final output file is in other qureies group. Apart form the regular process advanced process fetech the folder from share point can u please suggest me some links.

Regards

[negi007]

@Anonymous Not sure exactly what you want to do. But if you need help in connecting sharepoint folder to powwerbi, below are few links that can help you on this

https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/

https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder

https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/#:~:text=Open%20up%20PowerBI%20Desktop%20and,and%20click%20Connect%20to%20continue.&text=Upon%20clicking%20connect%20you%20will,site%20that%20we%20identified%20above.

if above does not help, please write back with details that you are trying to achieve

[ERD]

Hi @Anonymous ,

What do you want to achieve? Avoid automatic creation of Transform file/Helper Queries groups?

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

[Anonymous]

@ERD @negi007  Thanks for the reply.

Currently i am using regular process and it is working fine but couldn't understand what's going  in back end like parameter creating & linking the paremeter to sample file and creating function etc and apart form how can i do this manually..? 

[ERD]

@Anonymous ,

Are you working with SharePoint Online or SharePoint On-Prem?

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

[Anonymous]

@ERD We are using share point online

Regards

[ERD · Accepted solution]

@Anonymous ,

In this case here is much better way to import files from SPO (I believe this is what you need to achieve your goal):

A cleaner way to import files from a SharePoint folder with a Power Query function.

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

[Anonymous]

@ERD  i have .html files (Mutliple files) in share point on-premis folder below 

any idea what is the best to connect to the files 

Thanks in advance