Forum Discussion

Pavan_123456789's avatar
Pavan_123456789
Icon for Helper III rankHelper III
2 years 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"
Pavan_123456789's avatar
Pavan_123456789
Icon for Helper III rankHelper III
2 years 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
2 years 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.