Forum Discussion
Query Parameters not showing in Service
Hi MattMcMillin_71 ,
t looks like you have defined parameters in your Power BI Desktop model, but they are not showing up in the Power BI service when you publish your report. This may be caused by a number of factors, such as incorrect publishing settings or a mismatch between your Power BI Desktop version and the Power BI service version.
To ensure that your parameters are published correctly, you should check the following:
-
Make sure that you have enabled parameter loading in the "Options" menu of the "Power Query Editor" in Power BI Desktop.
-
When publishing your report, ensure that you have selected the "Include Selected Parameters" option in the "Advanced" tab of the "Publish to Power BI" dialog box.
-
Check that the Power BI Desktop version you are using is compatible with the Power BI service version you are publishing to.
If you have already checked these settings and are still having trouble, you may want to try publishing the report to a different workspace
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for this - 2 questions.
Where in your screen shot is the option to enable parameter loading?
When I do the publish step, I dont see an advanced tab - could you screen shot that for me please
I have had the parameters working previously but for some reason the past week has seen them drop out of the service.
Reaslly appreciate your help/input, its great
what i see when publish
Hi MattMcMillin_71 ,
Sorry, you can Load parameters in power query. However , the advanced tab that I didn't find it.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.