Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Pavan_123456789
Helper II
Helper II

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[Month]) VAR Final = CALCULATE( SUM('Financial Data (3)'[QUANTITY SHIPPED]), 'Financial Data (3)'[YEAR] = _Year, 'Financial Data (3)'[MONTH] <= _Month, 'Financial Data (3)'[EXTERNAL INTERCOMPANY] = "External" ) RETURN Final

In the paginated matrix table visual, I've created parameters for Calander[Month] and Calander[Year] and published the report to the Power BI service. However, when I attempt to set up these parameters in a new PBIX file, I encounter an error indicating that there is no connection between the Calander table and the Financial Data (3) table.

Note : There is no relationship B/w the Calander table and the Financial Data (3) tables.

Could you please assist me in resolving this issue? I appreciate your guidance.

Thank you for your support!

3 REPLIES 3
v-fenling-msft
Community Support
Community Support

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:

vfenlingmsft_0-1727687744507.pngvfenlingmsft_1-1727687771510.png


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

vfenlingmsft_2-1727687843600.png

vfenlingmsft_3-1727687880773.png

 

vfenlingmsft_4-1727687906241.png

 


Then create a parameter Month:

vfenlingmsft_5-1727687944964.png

 


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

vfenlingmsft_6-1727688012022.png

 


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:

vfenlingmsft_7-1727688097080.png

 

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

vfenlingmsft_8-1727688128819.png

 

vfenlingmsft_9-1727688168101.png


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

vfenlingmsft_10-1727688251825.png


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

vfenlingmsft_11-1727688309162.png


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

vfenlingmsft_12-1727688358810.png

 

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.

Hi @v-fenling-msft 
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?

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors