Forum Discussion
Transferring Power BI dataset to dataflow, getting Token Eof expected error on custom column
- 6 years ago
Hi. I think you are confused. That code is DAX. DAX is a query language that runs over a data model already built. The edit queries or transform data in power bi desktop works with power query. In power query, the queries will run over the data source in order to build the data model. They are a previous step. Dataflows works with power query too.
You can't copy a DAX code there because it uses a completely different language.
If you want to move to dataflows you have to move your power query code. Then connect your power bi desktop to the dataflow and use the same dax code in both of them.
I hope I have explained myself. It's a lot to talk about.
Regards,
Hi. I think you are confused. That code is DAX. DAX is a query language that runs over a data model already built. The edit queries or transform data in power bi desktop works with power query. In power query, the queries will run over the data source in order to build the data model. They are a previous step. Dataflows works with power query too.
You can't copy a DAX code there because it uses a completely different language.
If you want to move to dataflows you have to move your power query code. Then connect your power bi desktop to the dataflow and use the same dax code in both of them.
I hope I have explained myself. It's a lot to talk about.
Regards,