The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredAsk the Fabric Databases & App Development teams anything! Live on Reddit on August 26th. Learn more.
In a Direct Lake Semantic Model connected to a Lakehouse, columns renamed in the service behave as expected, but columns renamed using Tabular Editor 2 revert to their original name after certain actions.
To reproduce:
At this point, the columns renamed in the service are still renamed, but the columns renamed in Tabular Editor have reverted to their original name.
1) Create a Direct Lake Semantic Model connected to a Lakehouse.
2) Rename some of the model’s columns from the service / web interface.
3) Rename a different model column from Tabular Editor and save the changes.
4) Verify from the service that the Tabular Editor changes did get saved to the model.
5) Click on Edit Tables, make no changes, click Confirm.
6) After the model reconnects to the underlying tables, check the column names again.
I just confirmed if you rename a column from web first, then rename it some more from TE, then do the "Edit Tables" step, the name does not revert. Changes made in TE stick if that column has been changed in the service first. There must be a background meta flag that TE doesn't set properly, but the service does.
Hi @JustinHylton ,
Thanks for the exhaustive reproduction process. By checking the documentation for Tabular Editor, I found that this feature may require a paid version of Tabular Editor 3.x to be supported. You can further confirm this with Tabular Editor officials.
Tabular Editor 3 -- Contact us
Using Tabular Editor in Microsoft Fabric – Tabular Editor Blog
Learn about Direct Lake in Power BI and Microsoft Fabric - Microsoft Fabric | Microsoft Learn
A limitation is mentioned here. But the restriction of clicking to jump to the official documentation seems to have been removed.
Fabric Direct Lake with Tabular Editor – Part 2: Creation – Tabular Editor Blog
And unable to find documentation related to Direct Lake Semantic Model under Tabular Editor 2.x.
Hope these help.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Thank you. Your research is helpful.
I still find it odd that the changes do get pushed to the service and appear to work, but later get reverted. Or, if you rename the column once in the service, you can rename it successfully in Tabular Editor. I wonder if the fabric developers know of this issue. It seems like either Tabular Editor needs to set a flag variable, or the Fabric team needs to check for renamed columns even if that variable is not set.
Thanks again.
User | Count |
---|---|
4 | |
2 | |
2 | |
2 | |
2 |
User | Count |
---|---|
10 | |
8 | |
7 | |
6 | |
6 |