[Issue] : Facing issues while importing a table in AAS model using TE3

[kkmalik89]

Describe the issue
A clear and concise description of what the issue is.

** Which version are you currently using? **
3.10.1

To Reproduce
Are you connected to SSAS/AAS/Power BI or working offline? - AAS

Steps to reproduce the behavior:

1. Import the model in TE
2. Right click on Tables and import tables.
3. Choose any table/view. It shows 'Update Schema' popup.
4. See error

Expected behavior
Table import successful.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• Windows version: 11

Additional context
Add any other context about the problem here.

[otykier]

Hi @kkmalik89
Are you connecting to a dedicated synapse SQL pool, by any chance? If so, we are currently aware of an issue in that regard, and will make a fix available with our next update.

As a workaround, enable Use Analysis Services for change detection and import tables by copying existing ones, modifying the M expression, and running a schema update, as described here.

[otykier]

Fixed in 3.12.0, thanks for reporting!

[kkmalik89]

Hi @kkmalik89 Are you connecting to a dedicated synapse SQL pool, by any chance? If so, we are currently aware of an issue in that regard, and will make a fix available with our next update.

As a workaround, enable Use Analysis Services for change detection and import tables by copying existing ones, modifying the M expression, and running a schema update, as described here.

Yes, We are connecting to Synapse dedicated SQL pool.

[kkmalik89]

Fixed in 3.12.0, thanks for reporting!

Thanks. Will download this version.

[kkmalik89]

It works in version [3.12.0]. Thanks @otykier !!

[otykier]

Thanks for the confirmation :)