Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.