Forum Discussion

Pavan_123456789's avatar
Pavan_123456789
Icon for Helper III rankHelper III
1 year ago

Assistance Needed with Paginated Report Parameters

  I am currently working on a paginated report that utilizes a measure for selected year sales, defined as follows:   dax:- 23 Qty = VAR _Year = MAX(Calander[Year]) VAR _Month = MAX(Calander[Mon...
"Need Help"
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, Pavan_123456789 

May I ask what type of data source you have? How were your parameters created? What exactly did you do to cause the error to occur?

 

In my test, I created two tables in SQL Server:


Since the two tables are not related, I created two Dataset connections in Power BI Report Builder agreeing to different tables in different databases:

 

 


Then create a parameter Month:

 


Then create a Matrix, drag the fields from Dataset2 to the Matrix and publish to Power BI Service:

 


After publishing to Power BI Service, open Power BI Desktop and connect to SQL Server to import the two tables created into Power BI Desktop:

 

Then create a paginated report visual, click Connect to report ,select the report just published to Power BI Service:

 


Drag the CalanderTable's Month field to parameter and select Month in the select related field:


Create a Slicer and drag the CalanderTable's Month field to the Slice's field:


Select the corresponding Month and click Apply change in the paginated report visual:

 

I hope you find the above examples helpful!

 

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Pavan_123456789's avatar
    Pavan_123456789
    Icon for Helper III rankHelper III
    1 year ago

    Hi Anonymous 
    Thank you for your replay ,

    I would like to provide some additional context on the issue I'm currently facing with my Power BI setup.

    Both of my tables—Calendar and Financial Data (3)—are sourced from SQL In Pbix File , and I have created the necessary DAX measures within the PBIX file. After publishing the PBIX file to the Power BI service, I used the Pbix dataset in a Paginated Report, which I then published to the Power BI Service as well.

    Subsequently, I utilized that Paginated Report in a new PBIX file. However, I encountered an issue when trying to add parameters from the Calendar table. Since there is no existing relationship between the Calendar table and the Financial Data (3) table, I receive an error indicating that there is no connection between the two tables.

    Could you please assist me in establishing the necessary relationships or suggest an alternative approach to resolve this issue?

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi, Pavan_123456789 

      Thank you for your reply.

       

      I have some questions about your steps:
      May I ask then what you are talking about:

      After publishing the PBIX file to the Power BI service, I used the Pbix dataset in a Paginated Report

      Do you mean that you used Power BI Report Builder to connect to the pbix file that you first published to Power BI Service? Which specific application are you using in this step? Was it a pbix file or an rdl file that was created?

       

      Secondly, in the following what you said:

      I utilized that Paginated Report in a new PBIX file

      What does it mean again? Is this new pbix file that you are recreating now in Power  BI  Desktop or do you mean the previous first publish to Power BI Service or the first publish to Power BI Service?

      By parameters do you mean specifically the parameters of Power BI Report Builder or the parameters of Power BI Desktop?

       

      Do you have Year and Month fields in both tables?

      Please give me some more detailed information.

       

      I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
      Best Regards,
      Fen Ling,
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.