Many-To-Many But ISNT

[Anonymous]

I have a one to many relationship that Power BI is classifying as Many to Many. I even reduced one table to a single column and a single row, Power BI is still convinced it is a Many To Many.

[v-qiuyu-msft]

Hi @Anonymous,

Would you please share the pbix file with us? You can upload it to your OneDrive and share the link here. 

Best Regards,
Qiuyun Yu 

[Anonymous]

I could, but the PBIX is in Direct Query Mode and I believe the tables will provide no information for those without permission.

Oddly, if I switch to import mode, it works fine. However, this use-case requires direct query mode.

Any ideas on sharing a direct query PBIX?

[Gkevorkian]

Any resolution to this issue? I am having the same issue