Query Processing Issue: Table Loading in Transform Data Tab Instead of Data pane Tab

Hi Suraj_Ncircle ,

When you see the "Processing Query Determining automatic transformations.." window, Power BI is attempting to optimize the data import process by analyzing the data structure and content. This step is crucial for ensuring that the data is in the best possible format for analysis within Power BI. The window provides an option to skip this step, but it's generally recommended to allow Power BI to complete this process for optimal data handling. This automatic transformation step is part of Power BI's effort to streamline data preparation tasks.
Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Learn
Regarding your observation of the table loading in the Transform Data tab instead of the Data pane tab, this behavior is by design when using the "Transform Data" option. When you choose to load data, Power BI provides two options: "Load" and "Transform Data". Selecting "Transform Data" opens the Power Query Editor, which is where you can apply transformations and manipulations to your data before it's loaded into the model. This is why you see your table in the Transform Data tab. If you wish to load the data directly without transformations, you should use the "Load" option. However, since you're developing a custom connector with parameters, it's likely that users will need to transform or filter data, which is why they're directed to the Transform Data tab.
Quickstart: Connect to data in Power BI Desktop - Power BI | Microsoft Learn
And for implementing custom parameters in your connector, ensure that the parameters are correctly defined and that the user interface for inputting these parameters is intuitive. Power BI allows for dynamic interaction with parameters, enabling users to filter data as needed.
If you have other problems, perhaps it may be due to the custom connector you created, if you can, please describe in detail how your custom connector works. Thank you !

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.