cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shwetketu New Member
New Member

Changing headers when changing data source

Hi,

I wanted to know how to replace headers of the source data when changing the data source. In brief, I created a dashboard with the data source as an excel extract of a oracle database. Now, I've managed to create a live connection with the DB. The issue I'm facing is that although the table structure and data in it is same, the column headers in the excel file and the DB are different. I do not want to re-create the visuals using the new headers and simply want to replace the existing excel file with the DB connection and change the column headers names to that of the excel file so that visuals use the live data from the DB. 

To illustrate:

Original Column Headers

New Column Headers

Project

PROJECT_ITID

Name

WORK_PROJECT

Client

CLIENT_ITID

% of Variable component

COMMERCIAL_VARIABLE

% of Fixed Component

COMMERCIAL_FIXED

 

In the table above the  ORIGINAL COLUMN HEADERS are the fields which were in the excel file on which the dashboard visuals are based. The NEW COLUMN HEADERS are the fields in the DB. Now how can I change the data source to the DB and ensure that my visuals use the new column headers.

 

2 REPLIES 2
Highlighted
v-haibl-msft Super Contributor
Super Contributor

Re: Changing headers when changing data source

@Shwetketu

 

We can change the power queries in Advanced Editor as below, like changing the source and adding a rename action. The original data source is excel, and we can change it to SQL Server. 

 

You can create a new PBIX file to get data from the db directly to see the generated power queries by Power BI. So that you can replace the power queries with above ones in the original PBIX file which get data from excel file.

 

Changing headers when changing data source_3.jpg

 

Best Regards,
Herbert

v-haibl-msft Super Contributor
Super Contributor

Re: Changing headers when changing data source

@Shwetketu

 

Does it work on your side now?

 

Best Regards,
Herbert

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 115 members 1,720 guests
Please welcome our newest community members: