Forum Discussion

ITManuel's avatar
ITManuel
Responsive Resident
2 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 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

     

Anonymous's avatar
Anonymous
Not applicable
2 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