Forum Discussion
Many to Many relationships in PowerBI
We have a star schema in a SQL azure database. One of our dimensions tables run some 200 rows. Given power bi max filtration options of (~100) and the ease of use; we have decided to create another ca...
mageeb May be its worth trying below. (I have).
I had relational db with many PK FK relations and to not wanting to do this manually in powerbi desktop, I initally connected to my database using DirectQuery. Once connected and saved pbix file, I changed it to import by clicking on the link on bottom right which says 'DirectQuery enabled click to change'. This helped me replicate my db PK FK relations without needing to create manually.