How to display business names of SAP Datasphere data in Power BI

[Lora0121]

Hello,

I followed the procedure to connect Power BI to SAP Datasphere using the ODBC connector.

In Power BI, only technical names are displayed.
Do I have to manually change the column names to business names using the 'Rename Columns' function in Power Query?
I want to publish and reuse the data with the changed column names,
so that I don't have to change the column names every time I create a report.

Is this possible? Thanks in advance.

[Anonymous]

Hi @Lora0121 

Did Sergii24 's method solve your problem? If yes, could you please mark it as solution? This will help more users who are facing the same or similar difficulties. Thank you!

If you still have questions, please feel free to ask me.

Best Regards,
Yulia Xu

[Sergii24 · Accepted solution]

Hi @Lora0121, usually "Display Name" value is present in source database. You'll need to search for it as it's not given that it is going to be available in every table of your data source. I suppose, that "tehcnical name" is used in most of them, but then you should have another dimensional table that contains pairs "Technical Name" - "Display Name".

However, if you want to reuse the connection that you're building for multiple reports, consider the use of dataflows to apply transformations common for all subsequent reporting (What are Power BI Dataflows and their Use Cases? - RADACAD).

Good luck with your project! 🙂