Forum Discussion
Helper VFabric - semantic model performance
Community Champion1) I don't know, perhaps a bug in the user interface?
2) I believe only visuals which use the View will fall back to DirectQuery. Other visuals should be unaffected and keep using Direct Lake.
This can be tested, if you turn on "Direct Lake Only", then you will see the DirectQuery visuals failing.
Or you can open the reports in Power BI Desktop, and use performance analyzer to check for a DirectQuery activity.
If some visuals fall back to DirectQuery, then that is probably the biggest performance issue.
Here I am using Performance analyzer in Power BI desktop to query a table and also a similar view. The view causes a fallback to DirectQuery.
Helper Vthanks, I get results like below even thought all tables accessed by the query are tables
- frithjof_v
Perhaps the query is just too big, then it falls back to DirectQuery.
Did you enable SQL granular permissions on any of the tables? In that case, it may fall back to DirectQuery.
Did you try using the "Direct Lake Only" setting?
- joakimfenno
I tried direct lake only but that gives me error message wven though this specific report/visual do not consume anything other than tables
no granular permission (only full on model level) are used
- frithjof_v
It seems your queries fall back to DirectQuery.
Does it fall back even if you make a report page with a very simple visual (a card visual which just shows the sum of a column)?