Forum Discussion
Power BI Desktop automatically changed column names like Column1 as Attribute1, Column2 as Attribute
Hello All, We are facing a new issue with Power BI, When I refresh the report in service looks everything fine.But when I refresh in local through Power BI Desktop the column names are automatically gets changing.I'm not getting the reason and specially Dimension table are behaving like this and We are using SAP HANA DB as database. Below is the customer table for reference:
Normally it should be like above.
As per my knowledge from June it is creating the issue like below
And these are straight forward columns which we are taking from HANA DB, we are not doing any from our Power Bi end.
Please do the needful.
2 Replies
Hi Dkumar11 ,
It sounds like you may be experiencing an issue with field names being changed after refreshed the data in Power BI when connect to an SAP HANA database. This could be due to a number of factors, including changes in the database schema or settings in Power BI.
One possible solution would be to try renaming the fields in Power BI after refreshing the data. Another option would be to check the settings in both Power BI and the SAP HANA database to ensure that they are properly configured to handle field names.
Power Query SAP HANA database connector - Power Query | Microsoft Learn
SAP BW/4HANA Connectivity Options in Microsoft Power BI | SAP Blogs
Best Regards
