[Issue] TE 3 V10.1 : Unable to update the table (Unknown error while parsing M expression)

[nimishnagpal]

Describe the issue
I am unable to update the schema of the table using the [Update table schema..] option on right click options of the table on the tabular model.
Error Message: Unable to detect schema changes on the table 'CheckHold': Unknown error while parsing M expression: Object reference not set to an instance of an object.

This [Update table schema..] option is working for the SSAS (onprem) model but NOT WORKING for the PowerBI Premium Dataset.

** Which version are you currently using? **
Tabular Editor 3, version: 3.10.1.16685
Tabular Editor 3 edition: [Enterprise]

To Reproduce
Connect with the PowerBi Premium model.
Tabular Editor connects to the PowerBi Premium dataset. The PBIP dataset is connected to the SQL Server database (On-Prem) using PowerBi Gateway.

Steps to reproduce the behavior:

1. Connect TE 3 to PowerBi Premium Model
2. Right Click on the table
3. choose the first option [Update table schema..]
4. See error

Expected behavior
Expected to work like this. Detecting schema.

Screenshots

Desktop (please complete the following information):

• Windows 10

M Query
This same is able to refresh the table properly, which means there is no issue in the M query.

let
    Source = #"DBConnection",
    dbo_tableA = Source{[Schema="dbo",Item="TableA"]}[Data]
in
    dbo_tableA 

[mlonsk]

Hi @nimishnagpal

Could you try to enable the setting "Use Analysis Services for change detection" when connected to the Power BI Premium Dataset. This will allow the Power BI service to parse the M code und return the schema.
Depending on the M code it is not always possible for Tabular Editor 3 to retrieve the schema.

[otykier]

@nimishnagpal could you share the M query stored in the "DBConnection" shared expression? (Please blank out any sensitive information). Thanks!