Forum Discussion
Power BI dataflow calculate DAX
May I know a dataflow can calculate DAX inside it ?
If I am connecting to a shared dataset using live connection , in that report , can I still get any data from other sql database?
1 Reply
Dataflows use Power Query, not DAX. You can perform many of the same calculations in Power Query as DAX, however these will be pre-calculated values, saved in the dataflow, and then imported into the Power BI data model.
You can create composite models, leveraging Live Connection from a shared dataset and importing or DirectQuerying data from SQL Database: Use composite models in Power BI Desktop - Power BI | Microsoft Docs
