topic BUG Tables added to semantic model are duplicating schema and don't work in reports in Data Warehouse

BUG Tables added to semantic model are duplicating schema and don't work in reports

arpost — Tue, 12 Mar 2024 15:00:05 GMT

Greetings, community. I have a semantic model I created on top of a Fabric data warehouse in which tables that get added seem to be duplicating schemas, which breaks reports. In the fake example below, this is what I get when I add a column from the affected table into a report. should be "abr.Store" not "abr.abr.Store". This seems to be an under-the-hood issue as none of this is reflected in the name of the table itself.

Anyone else having this issue? Really frustrating as it makes it impossible to create semantic models in the Service on top of Fabric. I know there is another bug with semantic models that has been reported (community link), but that is different from this bug.

The steps are as follows:

Click New semantic model on the Reporting tab of the Fabric Data Warehouse.
Select tables/views you want to view and save.
Open new semantic model.
Click Open data model.
Click Edit tables.
Add new tables.
Connect to DW with report.
Add fields to visual.
Get error.

Re: BUG Tables added to semantic model are duplicating schema and don't work in reports

v-cboorla-msft — Wed, 13 Mar 2024 10:47:47 GMT

Hi arpost

Thanks for using Microsoft Fabric Community.
At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.

Appreciate your patience.

Thanks.

Re: BUG Tables added to semantic model are duplicating schema and don't work in reports

v-cboorla-msft — Thu, 14 Mar 2024 12:01:18 GMT

Hi arpost

Apologize for the inconvenience that you are facing here.

Please reach out to our support team to gain deeper insights and explore potential solutions, If its a bug, we will definitely would like to know and properly address it. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thank you.

Re: BUG Tables added to semantic model are duplicating schema and don't work in reports

arpost — Thu, 14 Mar 2024 13:17:38 GMT

I have already worked with Microsoft support on this issue, and they mentioned a bug had been reported internally. No timeline on a fix was given, though. Ticket # is 2402230040013496

topic **BUG** Tables added to semantic model are duplicating schema and don't work in reports in Data Warehouse

**BUG** Tables added to semantic model are duplicating schema and don't work in reports

Re: **BUG** Tables added to semantic model are duplicating schema and don't work in reports

Re: **BUG** Tables added to semantic model are duplicating schema and don't work in reports

Re: **BUG** Tables added to semantic model are duplicating schema and don't work in reports

topic BUG Tables added to semantic model are duplicating schema and don't work in reports in Data Warehouse

BUG Tables added to semantic model are duplicating schema and don't work in reports

Re: BUG Tables added to semantic model are duplicating schema and don't work in reports

Re: BUG Tables added to semantic model are duplicating schema and don't work in reports

Re: BUG Tables added to semantic model are duplicating schema and don't work in reports