Forum Discussion

hama21's avatar
hama21
Helper I
3 years ago
Solved

Help with changing data type through tabular editor and dataset on service

I have a dataset in my workspace that was created through a .pbix that I uploaded and I changed all the tables from directquery to import via tabular editor. It was done that way because the tables are big and the desktop had no RAM and it was unfeasible to work in .pbix on the desktop.

However, now I have a column in one of the tables, which I need to change the data type. It has already been exchanged in dataflow. When I connect to my dataset through the tabular editor, I perform the same data type change in the column, deploy and save. This modification doesn't happen in my dataset in the service and I can't change the column data type. Does anyone know the reason why I'm not able to change the data type by the tabular editor in my dataset?

Thanks

  • Hi hama21 

    Thanks for reaching out to us.

    There are some limitations when using Tabular Editor (any edition) as an external tool for Power BI Desktop, please read this article, Power BI Desktop limitations | Tabular Editor Documentation

     

     

    Best Regards,

    Community Support Team _Tang

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

2 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Community Support

    Hi hama21 

    Thanks for reaching out to us.

    There are some limitations when using Tabular Editor (any edition) as an external tool for Power BI Desktop, please read this article, Power BI Desktop limitations | Tabular Editor Documentation

     

     

    Best Regards,

    Community Support Team _Tang

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

  • Manichin's avatar
    Manichin
    Frequent Visitor

    Is it possible to change datatype of a column via tabular editor. the source of the dataset is excel spreadsheet from sharepoint?