Report builder error 400 when selecting columns from 2 different dimensions

[Anonymous]

Hello, 

I am working on a report that is connected to a Power Bi data source.

I need a dataset that takes fields from two different dimensions.

So i have dimensions 1 and 2 and i would need columns a,b,c from dimension 1 and column d from dimension 2.

when I run the report with only the colums from dimension 1 it runs without any issue, when i drag in the column from dimesnion 2 into the query however I get an error 400.

Is there any way that I could fix this?

Thank you.

I have attached a screenshot of the error i'm geting when trying to run the report with columns from both dimensions.

[amitchandak]

@Anonymous , Select something from a common fact, and check.  seem like large data is getting generated for this combination.

[Anonymous]

When i try selecting another column from dimension 2 it runs well, the problem seems to be with the specific column i need