Query Parameters not showing in Service

[MattMcMillin_71]

I am trying to have the query paRAmeters created in the Desktop report appear in the settings of the published report. However it is saying:

The date field is date/time, so I am not sure what I am missing - any ideas (please)?

[Anonymous]

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:

1. Make sure that you have enabled parameter loading in the "Options" menu of the "Power Query Editor" in Power BI Desktop.

2. 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.

3. 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.

[MattMcMillin_71]

this is what I have selected currently

[MattMcMillin_71]

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

[Anonymous]

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.

[MattMcMillin_71]

what i see when publish

[MattMcMillin_71]

It has sensitive customer info, so no unfortunately, I could share the code with the various steps maybe?

[tharunkumarRTK]

@MattMcMillin_71 

May be you can create a new blank report with sample data and share it here.

[tharunkumarRTK]

@MattMcMillin_71 

Can you share the PBIX file?