Data not showing or allowing in selection screen field drilldown

[Anonymous]

We are facing issue to read one of our stock report into PowerBI via direct query, as with the calday variable when its is exposed to PowerBI system does not allow to input any values to the selection screen.

[v-diye-msft]

Hi @Anonymous ,

For the data not showing when you drilldown to the calday variables, reason is the time hierarchy is an limitation for direct query mode. For more details, please check the online document.

https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery

Best regards,

Dina Ye

[v-diye-msft]

Hi @Anonymous 

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

Best regards,

Dina Ye