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
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!

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        1. Build number - Version 1.1.6514.9163 (October 2017)

        2. No Error messages are being put in the ReportingServicesService*.log file with any information details, just every time we go into the subscription it states the following: 

         

        An error has occurred.

        Something went wrong. Please try again later.

         

        3. Get the same issue in Chrome and IE

         

        These reports are referencing Shared Datasets and the values are cascading, so based on another parameter value selection that is filtering the list of values.  This works in SSRS 2016, but not working in PBI RS Oct 2017.

         

        So maybe it is because of the filtering from the first parameter value?  Does that work for you if you set a parameter up like that?