Report builder error 400 when selecting columns from 2 different dimensions

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.