Forum Discussion
Not able to create calculated column in Semantic Model
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.
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.