Time Discrete view for power bi.
We use ADX as time series DB and
a BI dashboarding tool (power bi)
But BI don't like non Discrete time events, no calculations are possible, and the Bi aggregation are calculated not correctly (group by, avg)
If we have a time discrete view , every BI tool will work very lovely.
Make series are nice, but will not work , because it's in the pipelines before power bi, and the query optimizer will fail, an calculating a make series for all our 3 million device's an than lock to the power bi where time and device filter.
Maybe a better qeury optimizer, a power bi connectors, how made the make series command after the where, a new command, or something better needed.