Solved: Loading data via SharePoint Folder

Russo · ‎10-06-2025

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 · ‎10-06-2025

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

View solution in original post

MasonMA · ‎10-06-2025

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