Forum Discussion
Creating a calculated table in PowerBI Service dataflow
In PowerBI Desktop, there is the option (Table tools -> New table) to create a new calculated table using DAX, for example via the ADDCOLUMNS or UNION functions.
I cannot find this option when adding the queries for a dataflow in our Premium Per User workspace.
Is this functionality not available (yet?), or am I overlooking something, or am I trying to use a dataflow for something it is not intended for ?
Thanks!
Hi, SteffanH ;
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.
https://docs.microsoft.com/en-us/power-query/dataflows/data-sources?tabs=power-bi-service
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi, SteffanH ;
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.
https://docs.microsoft.com/en-us/power-query/dataflows/data-sources?tabs=power-bi-service
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.