Forum Discussion

topcat777's avatar
topcat777
Frequent Visitor
6 years ago
Solved

Transferring Power BI dataset to dataflow, getting Token Eof expected error on custom column

Hi All   I am transfering a large dataset that takes ages to refresh in PowerBi desktop to a Dataflow on the PowerBi online service. I have the follwing Custom Column in my current desktop quiery. ...
  • ibarrau's avatar
    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,