Paginated reports issue: Crossjoin based on dataset

[VishalSukhija]

Hello,

We are creating a paginated report based on a dataset. In dataset we have join/relation defined between Calendar dimension (generated in Power BI) and a fact table (from Oracle Database):

We use this dataset to create paginated report and data was not coming properly. On further analysis we noticed that the joins are not working properly, in Power BI Report Builder the data is pulled with cross join between the two tables:

When we try to build similar report suing same dataset in Desktop App or Power BI Services, the data comes fine:

Please guide on how to get the paginated report working.

Thanks,

Vishal

[v-chuncz-msft]

@VishalSukhija 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/SSAS-Tabular-Queries-Disregard-Model-s-Relationships-Unless...