Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Solved! Go to Solution.
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.
Is it possible to change datatype of a column via tabular editor. the source of the dataset is excel spreadsheet from sharepoint?
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
57 | |
55 | |
55 | |
37 | |
30 |
User | Count |
---|---|
78 | |
66 | |
45 | |
44 | |
40 |