topic Unable to create schematic model for ADLS GEN 2 shortcut in Fabric platform

Unable to create schematic model for ADLS GEN 2 shortcut

prproddu — Tue, 28 Nov 2023 09:20:50 GMT

Am able to create Adls gen 2 shortcut with service principle auth type and able to preview the data.

However when I try to create schematic modle am not see the table in schema list.

@fabric

Re: Unable to create schematic model for ADLS GEN 2 shortcut

Anonymous — Tue, 28 Nov 2023 14:41:32 GMT

Hi prproddu
Thanks for using Fabric Community.
As I understand you have created a shortcut for a file/folder present in ADLS GEN2 in a Lakehouse. If you want to create a semantic model for this file, you can follow the below steps:

1) I have created a shortcut in the Lakehouse using ADLS GEN2.

2) Load the data present in the file shortcut to a table.

3) A table will be created in the lakehouse. Now you can create a semantic model using this table.

Hope this helps. Please let us know if you have any further questions.

Re: Unable to create schematic model for ADLS GEN 2 shortcut

Anonymous — Tue, 28 Nov 2023 18:18:30 GMT

Hi prproddu
Currently the complex column types are not supported for Direct Lake tables.
Appreciate if you could share the feedback on our feedback channel. which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Hope this helps. Please let me know if you have any further queries.

Re: Unable to create schematic model for ADLS GEN 2 shortcut

Anonymous — Tue, 28 Nov 2023 18:09:55 GMT

Hi prproddu
Please review the data types in the tables to verify that there isn't anything that might not be supported.
Please refer to this link: Direct Lake in Power BI (Known Issues and Limitations section)

Example : Direct Lake tables do not support complex delta table column types. Binary and Guid semantic types are also unsupported. You must convert these data types into strings or other supported data types.

Hope this helps. Please let us know if you have any further questions.

Re: Unable to create schematic model for ADLS GEN 2 shortcut

prproddu — Wed, 29 Nov 2023 08:40:46 GMT

AnonymousWe don't use any complex data types in our table shortcuts. We can create a semantic model when we use Account Key to create shortcuts from ADLS Gen2. But we have a problem creating a semantic model with shortcuts that use SPI.

Re: Unable to create schematic model for ADLS GEN 2 shortcut

Anonymous — Fri, 08 Dec 2023 18:39:24 GMT

Hi prproddu
Apologies for the issue. The internal team has confirmed that this fix should be deployed. This is on roadmap and is expected by Jan 2024.
Thanks.