Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

KINGMEMORY

Issues fixing Data Binding when source data has changes on the column, table name or database name

Submitted by on ‎09-30-2019 07:57 AM

I have created numerous reports and visulaiztions based on 50 MS sql databases and tables . One of the column names and/or Database location has changed, and I am unable to fix the binding in PowerBi, without completely removing the tables and starting over with all the steps performed on the table. Does anyone know how to update bindings when the source data name changes?

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎10-01-2019 02:11 AM

Hi @KINGMEMORY, 

 

You can open the report in Power BI desktop, go to Query Editor, select each table query, click on Advanced Editor, find the Power Query. You need to modify changed column/database name in Power Query. 

 

w3.PNG

 

After modifying Power Query, apply the change, ensure the report can be refreshed successfully in Power BI desktop, then republish the report to Power BI service. 

 

Best Regards,
Qiuyun Yu

Idea Statuses