cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hama21
Frequent Visitor

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

1 ACCEPTED SOLUTION
v-xiaotang
Community Support
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

vxiaotang_0-1664958303619.png

 

 

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.

View solution in original post

2 REPLIES 2
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?

v-xiaotang
Community Support
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

vxiaotang_0-1664958303619.png

 

 

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.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors