Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Using Import mode to bring in tables from a SSAS tabular model, the column names are full field names (table name included). Is there a way to have Power BI bring in the field name only?
Solved! Go to Solution.
Importing from SSAS is the least desirable approach to Power BI (in my view). Power BI has the same tabular modelling engine as SSAS tabular. You are effectively building a new model from scratch from an existing model. You should consider connecting live to the SSAS tabular model. If it doesn't meet your needs, consider the new composite model features https://exceleratorbi.com.au/the-most-important-update-to-power-bi-desktop-ever/
if for what ever reason those options don't work, your only option is to rename the columns. You can do this after import from the report view, or inside Power Query
Importing from SSAS is the least desirable approach to Power BI (in my view). Power BI has the same tabular modelling engine as SSAS tabular. You are effectively building a new model from scratch from an existing model. You should consider connecting live to the SSAS tabular model. If it doesn't meet your needs, consider the new composite model features https://exceleratorbi.com.au/the-most-important-update-to-power-bi-desktop-ever/
if for what ever reason those options don't work, your only option is to rename the columns. You can do this after import from the report view, or inside Power Query
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |