Loading data via SharePoint Folder

[Russo]

I'm loading a new excel sheet via Sharepoint folder.  After I find my sheet transform data and load it, I'm seeing a Helper Queries folder in my query editor now along with my table.  This folder has never appeared previously, wondering why they are there now?

[MasonMA · Accepted solution]

HI, Helper Queries folder is automatically created by Power BI whenever you connect to a SharePoint Folder (or any folder source).

Transform File defines the steps applied to a single sample file. Power BI uses this as a template for transforming all other files in the folder.

Parameter Queries store dynamic information such as the file path or name, so the process updates automatically when new files are added.

Sample File query used to define transformation steps.

I once removed all those helper queries after loaded parquet files from Synapse Azure by following this video. You can take a look if you are interested. 

https://youtu.be/2TeLzgkv1H0?si=zL4OmWdNSPrbIp1G