Forum Discussion

Ksven's avatar
Ksven
Advocate III
5 years ago
Solved

Dataverse Connector Limit for Import vs. Direct Query

Hi lovely Community,   currently I'm in trouble with my dataverse data model in power bi. I've a "huge" table with lot of columns and about 90K rows. If I query this table as dual or import mode I...
Need Help
Tips and Tricks
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Thanks for sharing the model pic, which shows it isn't a query issue but a model/DAX one.  The use of bi-directional filters is a discouraged practice, and you should consider using TREATAS() or CROSSFILTER() in your measure.  This article discusses both.

     

    Relationships in Power BI and Tabular models - SQLBI

     

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Thanks for sharing the model pic, which shows it isn't a query issue but a model/DAX one.  The use of bi-directional filters is a discouraged practice, and you should consider using TREATAS() or CROSSFILTER() in your measure.  This article discusses both.

 

Relationships in Power BI and Tabular models - SQLBI

 

Regards,

Pat