Forum Discussion

gvasquez's avatar
gvasquez
Regular Visitor
9 years ago

subscriptions parameters empty

View in subscriptions:     View when running report:   Hi,    We are running 14.0.600.398 and are seeing an issue with query backed parameters in subscriptions. The report will run ...
support reportserver
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi gvasquez,

 

I can also reproduce the issue in Power BI report server August preview version 14.0.600.398. If the parameter values comes from a dataset query, parameter values will not be listed when we create a subscription. 

 

 

But if the parameter values is specified values, parameter list is available for us to choose when we create a subscription. 

 

 

In your scenario, if the Entity doesn't have too many values, you can try the specified values for parameter temporarily. 

 

mgmeyerriccardomutichrisfin Please help look into this issue. Is it a known issue? 

 

Best Regards,
Qiuyun Yu

 

 

 

 

gvasquez's avatar
gvasquez
Regular Visitor
9 years ago

I wish I could unfortunately there are about 400 options in that parameter. Thanks for the help though, and I'm glad someone else can reproduce it.

  • rpatkar's avatar
    rpatkar
    Icon for Power BI Team rankPower BI Team
    9 years ago

    >>>If the parameter values comes from a dataset query, parameter values will not be listed when we create a subscription.

     

    Thanks for reporting the issue. We apologise for the inconvinience.

     

    A fix for this issue will be available in the upcoming GA release later this year.

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Icon for Community Support rankCommunity Support
      9 years ago

      Hi rpatkar,

       

      Thanks for your information. :smileyhappy:

       

      Best Regards,
      Qiuyun Yu 

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Any updates on this, we are running the Oct 2017 release and are still experiencing this issue with being able to Enter a Value for a parameter that references a Shared Dataset. All we see is the Select All option like the issue posted here and no values like we currently see in our SSRS 2016 environment.

       

      Thanks.

      • rpatkar's avatar
        rpatkar
        Icon for Power BI Team rankPower BI Team
        8 years ago

        hi Dan, I am not yet able to repro the issue on Oct 2017 build. Can you please help by providing the following information:

        1. build number (from '?' / 'About Power BI Report Server' menu item)

        2. any error you see in browser F12 or in log file (typically C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\ReportingServicesService*.log)

        3. does the issue repro after you clear the browser cache?

         

        Thanks!