Paginated Report had either the wrong values or blank values

[lliu_western]

Hi Community,

Has anyone ran into the problem where the paginated report that reference to a published PowerBI is showing empty or different value than in PowerBI? 

The stange thing is, some columns are showing it correct, but some are not and they are all from the same PowerBI report, using the same formating, aggregation, etc, in the Paginated report. PowerBI is displaying all the values just fine but not in the Paginated report. 

Please advise, thank you in advance !

[SivaMani]

@lliu_western,

Is the paginated report referring to different tables? I mean, are you using columns more than one table?

If yes, The PowerBI Dataset Relationships are not supported when accessed from 

Paginated Report Builder. Please refer this for more details - https://community.powerbi.com/t5/Desktop/Paginated-Report-Build-using-PowerBI-Dataset/m-p/848967/hig...