Forum Discussion
Solved
Star Schema cross-join
I'm creating my first PowerBI dashboard, using DirectQuery against an Azure SQL Data Warehouse instance, and am seeing strange cross-joins. When I add 1 fact table and 2 dimensions to the model a...
i don't think bidirectional will work with direct query mode
Disappointing, but that's reality sometimes. Thanks.
(maybe someday...)
Well, direct query mode has intrinsic technical challenges since the data do not live in the model. I will gladly trade directional relationships for ability to enhance direct query mode based models with calculations.