Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Change existing datasource from Sharepoint to OData



I'm new to powerBI and have an existing dashboard using SharePoint/excel file as the data source. Is it possible to switch the source to use an OData connection instead? If yes, how is this done? 



Super User
Super User

Create a second connection using ODATA. Make sure it produces exactly the same final result as your original query.  Then in Advanced Editor copy the resulting M code and place it into the original query. Once everything works you can remove the new query again.


Lots of backups!!! This is not a simple process and can break not just power query, but also visuals, measures, groups, renamed columns etc etc.

Helpful resources

T-Shirt Design Challenge 2023

Power BI T-Shirt Design Challenge 2023

Submit your creative T-shirt design ideas starting March 7 through March 21, 2023.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors