Forum Discussion
Helper ILoading data via SharePoint Folder
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.
Super UserHI, 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.