Share this article
Improve this guide
How to Change Data Source in Power BI
Learn what you need to do to replace the data source within minutes
2 min. read
Updated onOctober 4, 2023
updated onOctober 4, 2023
Share this article
Improve this guide
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
Key notes
Power BI is a very useful tool for creating a comprehensive view of your businessdata. You can visualize, shape, and share various sets ofdatawith the help of thisapp.
So, a very important feature is making changes to an existingdatasource. Read on to find out how to change the data source on Power BI.
How can I change the data source in Power BI?
-
Click onFile.
-
Go toOptions and Settings.
-
Click onData Source Settings.
-
Press on theChange Source…button.
-
Choose theFile pathfor the file you want to be the new data source using theBrowsebutton.
-
Click onOK.
The easiest way to change your data source in Power Bi is via Data Source Settings. All you need to do is manually browse for the new data source and replace the existing one with it.
This is the method we recommend you to use before any other, as it gets the job done most of the time.
Need more details about Power BI? Check out our comprehensive guide onhow to install power BI on your PC.
Why can’t I replace the data source in Power BI?
However, quite a few users encountered an issue with changing the existingdatasource:
When I’m trying to change my existingdatasource (MicrosoftAzure CosmosDB) to Blob Storage, the Change source is disabled. How do I workaround this? I have gone through various questions but none of them were similar to mine.
As thisuser from Stack Overflow forum saidand as the image below shows, theChange Sourcebutton is disabled, but fortunately, there are workarounds available.
What to do if I can’t update the data source via Settings?
In case the first method does not work when you try to replace your data source in Power BI, you should try the latter. It should fix any issues with the data source option being greyed out.
Changing thedatasource is an important feature to have. The inability to use this function could make the entire tool inoperable for many people.
Did you encounter a similar issue with Power BI? Did you find additional solutions on how to update the data source in Power BI? Let us know in the comment section below!
Milan Stanojevic
Windows Toubleshooting Expert
Milan has been enthusiastic about technology ever since his childhood days, and this led him to take interest in all PC-related technologies. He’s a PC enthusiast and he spends most of his time learning about computers and technology.
Before joining WindowsReport, he worked as a front-end web developer. Now, he’s one of the Troubleshooting experts in our worldwide team, specializing in Windows errors & software issues.
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Milan Stanojevic
Windows Toubleshooting Expert
Before joining WindowsReport, he worked as a front-end web developer. Now, he’s specialized in Windows errors & software issues.
