Skip to main content

Power BI

New

Add support for calculated columns that reference a datasource with SSO authentication in Power BI Service

Vote (19) Share
Carmen G.'s profile image

Carmen G. on 20 Jul 2021 12:14:55

We really like to use the composite models in PowerBI (Sharepoint files together with PowerBI dataset or Analysis Services using Direct Query), but we hit a limitation when publishing to Power BI Service. We tried to use a calculated column in a csv file for example, to get the proper key of a SCD type 2 dimension in an Analysis Service tabular model, in order to build the relationship between the two tables. It works perfectly in PowerBI Desktop, but it fails on refresh in Power BI Service. If this issue would be resolved, it would really allow us to use the composite models at full capacity.