Forum Discussion

Daviejoe's avatar
Daviejoe
Icon for Memorable Member rankMemorable Member
6 years ago
Solved

Paginated Reports - Subscription error when parameters return no data

Hi,   Set up a Power BI Paginated Report with 4 parameters;   Customer Size Location Type   about once a week my subcription will error or not send a report out as the selections set up mean...
Need Help
  • Daviejoe's avatar
    Daviejoe
    6 years ago

    I think I actually need to rebuild my model, will close this thread off, thanks for your suggestions everyone.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Daviejoe , There should be some message in power bi service on failure of these ?

  • Daviejoe's avatar
    Daviejoe
    Icon for Memorable Member rankMemorable Member
    6 years ago

    amitchandak hello hello, I thought you might reply to this one ğŸ˜€ğŸ˜‰

     

    The error I recieve is 

     

    The error while creating the subscription was:
    Report_Processing_Error: One or more parameters required to run the report have not been specified.

    This is because the parameter that the subscription was set up under, say a specific customer, has no data for that day.

    So the report errors out.

    I need to be able to have the report run but show that there is no data on that day.  So zero values essentially.

    Regards

    David