Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ashmozzart
Frequent Visitor

Rename columns in Power BI in Direct Query mode and Changing the Data source

Hi all,

I am doing power bi reports using Azure SQL DataWarehouse as the Data source using DirectQuery method.Here I got some issues.

 

1.I tried to rename columns in the Report,It is renaming the columns but the data is not getting Refreshed.It is throwing Error like this:

                  "This query contains transformations that cannot be used for a live connection"

I found the below link which says its possible.But i cannot refresh the data once i renamed the columns.

 

https://community.powerbi.com/t5/Integrations-with-Files-and/general-question-about-transformations-...

 

 

2.If it is possible to rename the columns within Power BI using Direct Query mode,If we change the Data source to another server,Will those renamed columns will automatically reflect in the new report as i am not changing any column names in the original source?

 

Thanks in Advance,

Ash

2 REPLIES 2
v-ljerr-msft
Employee
Employee

Hi @ashmozzart,

 

1. I just verified that I can rename the columns and refresh the data successfully with Direct Query mode.

 

rename.PNG

 

2. I think so. The rename step will be applied for the new data source as long as the data structures are the same.

 

Regards

Is this possible for live connection as well? When I tried to change the column names in my SSAS tabular model, the changes did not carry over into my reports.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors