Forum Discussion
ITManuel
2 years agoResponsive Resident
Column names when importing from SSAS
Hi, i know it is not best practice, but the company I work for has decided to use SSAS to provide raw data ( raw tables from an ERP system ) , without further data transformation and or data mode...
- Anonymous2 years ago
Hi ITManuel ,
When you import data from SQL Server Analysis Services (SSAS) into Power BI, the default behavior is to prefix the column names with the table name to ensure uniqueness, especially when dealing with multiple tables that might have columns with the same name.
In order for you to solve the problem faster, you can refer to the following documentation.How to Get Your Question Answered Quickly - Microsoft Fabric Community
Best Regards,
Albert He
lukiz84
2 years agoMemorable Member
SSAS to provide RAW data? what?
How are the data loaded to SSAS?
ITManuel
2 years agoResponsive Resident
The data source of SSAS is an MS SQL server. I have been told that the main reason for the SSAS in between is that security rules can be managed more easily for individual users / user groups down to column filters.
Br