Forum Discussion
Incomplete Data When Embedding Paginated Report into Power BI Desktop
Hi All,
Good Day!
I’m facing a challenge while embedding a Power BI Paginated Report into Power BI Desktop.
Issue: In the standalone Paginated Report, I can see the complete data. However, when embedding the same report into Power BI Desktop, some customer records are missing.
Report Setup:
Source: Power BI Semantic Model
Parameters:
Month/Year – Single selection
Sales Org – Single selection
Customer – Multiple selection
Investigation: The Month/Year parameter is mandatory and currently set to single selection (to handle large data volumes). When embedded in Power BI, the report filters data only for the selected month/year. As a result, customers without transactions in that specific period are excluded.
My requirement is to display all customers who have made transactions in the last 4 years. The table visual I created relies on multiple measures (Current Month, Same Month Previous Year, Previous Year, Previous Year -1, Previous Year -2), all driven by the parameter selection.
Attempted Workarounds: I tried changing the Month/Year parameter to allow multiple selections, but due to the large dataset, the report either fails to load or becomes unusable in Power BI Desktop/Service.
Could you please suggest possible workarounds or best practices to achieve this requirement? I need a way to show all customers across the last 4 years while still keeping performance manageable.
Thanks in advance for your help!
Add this measure to your table and you will see all your customers in 4 years, add your corresponding other measures as well as you request.
EVALUATE FILTER ( ADDCOLUMNS ( VALUES ( Customer[CustomerID] ), "Has4Y", CALCULATE ( [Sales Amount], DATESINPERIOD ( 'Date'[Date], MAX ( 'Date'[Date] ), -4, YEAR ) ) ), [Has4Y] <> BLANK() )
4 Replies
Hii MahammadJafar27
When a paginated report is embedded in Power BI Desktop, Desktop filters the semantic model first. Because your Month/Year parameter is single-select and applied at dataset level, customers with no transactions in that selected month are filtered out before the paginated report runs, which is why they appear in the standalone report but not when embedded.
Best practice is to keep a single As-Of Month parameter and internally expand it to a rolling 4-year date range, or remove the Month filter from the dataset and apply it inside measures only. This allows all customers active in the last 4 years to remain visible while keeping performance manageable.Add this measure to your table and you will see all your customers in 4 years, add your corresponding other measures as well as you request.
EVALUATE FILTER ( ADDCOLUMNS ( VALUES ( Customer[CustomerID] ), "Has4Y", CALCULATE ( [Sales Amount], DATESINPERIOD ( 'Date'[Date], MAX ( 'Date'[Date] ), -4, YEAR ) ) ), [Has4Y] <> BLANK() )Hi MahammadJafar27 ,
I would also take a moment to thank rohit1991 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions
Hi MahammadJafar27 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
