topic Re: Assistance Needed with Paginated Report Parameters in Report Server

Assistance Needed with Paginated Report Parameters

Pavan_123456789 — Fri, 27 Sep 2024 08:00:36 GMT

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!

Re: Assistance Needed with Paginated Report Parameters

Anonymous — Mon, 30 Sep 2024 09:27:29 GMT

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.

Re: Assistance Needed with Paginated Report Parameters

Pavan_123456789 — Mon, 30 Sep 2024 11:02:19 GMT

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?

Re: Assistance Needed with Paginated Report Parameters

Anonymous — Thu, 03 Oct 2024 09:19:28 GMT

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.