topic Re: Not able to create calculated column in Semantic Model in Data Warehouse

Not able to create calculated column in Semantic Model

lovishsood1 — Fri, 05 Jul 2024 10:22:58 GMT

Hi Team ,

I have created Dataflows which are pushing into Warehouse. I have created Custom Semantic Model out of that.

Now I want to create a Calculated Column for my Power BI dashboard and it is not available. It is showing disabled.

I have attached a screenshot. Do anybody what exactly I'm doing wrong here?

Re: Not able to create calculated column in Semantic Model

frithjof_v — Fri, 05 Jul 2024 10:26:54 GMT

If you want to create a direct lake semantic model, I don't think you can use calculated columns.

However, you can create calculated columns if you create an import mode semantic model in Power BI desktop, which uses the warehouse tables as it's source.

Re: Not able to create calculated column in Semantic Model

lovishsood1 — Fri, 05 Jul 2024 10:31:47 GMT

I tried the same but the problem I faced was that it kept giving me errors of Circular dependency though when I created the Power BI report without Fabric then it did not throw me any error on the same Calculated Column with the same Logic on it.

Re: Not able to create calculated column in Semantic Model

frithjof_v — Fri, 05 Jul 2024 10:50:40 GMT

Did you try importing the data into Power BI desktop like this:

https://community.fabric.microsoft.com/t5/General-Discussion/fabric-data-warehouse/m-p/4018054/highlight/true#M8611

Please try following the steps in my comment (link) to connect to your Warehouse's SQL connection string from Power Query in Power BI desktop. Steps 1-7 should be sufficient, then select the tables you want, and click Load to load the data into your data model in Power BI desktop (or click Transform data, then Close and Apply).

Then it should be possible to create calculated column without any error message.