Forum Discussion
Not able to create calculated column in Semantic Model
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?
Did you try importing the data into Power BI desktop like this:
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.
3 Replies
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.
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.
Did you try importing the data into Power BI desktop like this:
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.
