Forum Discussion

MattMcMillin_71's avatar
MattMcMillin_71
Helper I
2 years ago

Query Parameters not showing in Service


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)?

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      MattMcMillin_71
      Helper I
      2 years ago

      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

  • MattMcMillin_71's avatar
    MattMcMillin_71
    Helper I
    2 years ago

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