Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Query Regarding PBI Dataflows

Hi All, As I am delaing with large datasets, after reserach I found that the PBI Dataflows is best suitable option for same. I have designed a simple dataflow with defing bew tables form Oracls dat...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Anonymous ,

 

Dataflow entities that support direct query display the "view" icon in the Power BI desktop instead of the "table" icon, so no other transformations can be performed and can only be changed on the original data source.

 

To use DirectQuery with dataflows, you must explicitly toggle the enhanced compute engine to On in dataflow settings. You must then refresh the dataflow before it can be consumed in DirectQuery mode.

 

Direct query is different from import mode, and the above steps must be carried out.

 

For more details, you can read related document as below:

Using DirectQuery with dataflows - Power BI | Microsoft Docs


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


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