Connect a Dynamics view to Power BI using DirectQuery

(0) Share

Report

Posted on by Community member

I have a complex Dynamics table with around 1000 columns, which I'm trying to link to a live/near live Power BI dashboard using DirectQuery.

However, as you may expect, the dashboard performance is too slow for it to be usable; cached/imported data will not suffice, as end-users need to see live/near live data.

I was wondering:

a) is it possible to connect Power BI to a Dynamics View, to effectively force the filtering of the dataset to just the desired columns rows upstream to Dynamics and

b) would this improve dashboard performance?

Any other suggestions for improving performance appreciated, thanks!