Data source error{"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"Singl...
Hi kasparsveveris ,
According to your error message.You have used Direct Query connection mode in Power BI to connect to a datasource with a calculated column or a calculated table, which is currently not supported within the Power BI service.
- Limitations in calculated columns: Calculated columns are limited to being intra-row, as in, they can only refer to values of other columns of the same table, without the use of any aggregate functions. Additionally, the DAX scalar functions, such as
LEFT(), that are allowed, are limited to those functions that can be pushed to the underlying source. The functions vary depending upon the exact capabilities of the source. Functions that aren't supported aren't listed in autocomplete when authoring the DAX for a calculated column, and would result in an error if used. - Calculated tables: You can use calculated tables in DirectQuery when using composite models.
For more information, you can refer to：Modeling limitations - About using DirectQuery in Power BI
Or you can consider using another connection method to connect to your data source：
Dataset modes in the Power BI service
Using DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Best Regards,
Community Support Team _ Caitlyn