Change data source from one SharePoint to another SharePoint

[Syndicate_Admin]

Hello

I built a dashboard which has as a data source an excel that was in the Sharepoint A folder and I moved the excel to a SharePoint B folder, only when I try to change the data source to excel in Sharepoint B in Power BI in the applied steps I get an error in the navigation step :

Expression.Error: Table column 'Nombre_De_Tabla' not found.

How could I fix this.

Best regards

[v-alq-msft · Accepted solution]

Hi, @Syndicate_Admin 

I'd like to suggest you click 'Transform data'=>'Data source setting'=>'Change Source' with Sharepoint B=>click 'edit permisson' to sign in.

For further information about sharepoint folder connector, you may refer to the document .

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Syndicate_Admin , Create a connection from the second source in a separate file and check does it has that column: Nombre_De_Tabla, if not then you might have to remove that

refer: https://www.youtube.com/watch?v=h0yLtceT0i4