Direct query : problem with data

[Anonymous]

Hi,

I used direct query for load a big data frame but when I try to display a measure it returns nothing (vide)

And when I use import instead of direct query it works..

This is 3 screens to explain my problem, thanks !

 

[v-xiaoyan-msft]

Hi@Anonymous,

I'm sorry I can't reproduce your problem.

According to what you mentioned above, it works fine in import mode, but not in direct query.

Based on the known limitations, Please check if the underlying data source contains measures, such as SAP HANA or SAP Business Warehouse, then importing the data brings other issues.

It means that the data imported is at a particular level of aggregation, as defined by the query. But it's an issue for non-additive measures, such as Average, DistinctCount.

Also, AVERAGE function is not supported for use in Direct Query mode when used in calculated columns or row-level security (RLS) rules.

Please check if the mentioned data source is used, if the data source contains measures, and if RLS is included in the data source.

If this does not solve your problem, please provide more details and be free to let me know.

Articles for reference: Average-function-dax   About using DirectQuery in Power BI

Hope it helps.

Best Regards,

Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.