Power BI Desktop - How to change data source?

powerbi powerbi-datasource powerbi-desktop
Dee picture Dee · May 21, 2018 · Viewed 10.4k times · Source

When I'm trying to change my existing data source (Microsoft Azure 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.
Any help is much appreciated. Thanks enter image description here

Answer

rinjan picture rinjan · Jul 16, 2018

Workaround

  • Click on edit queries
  • Select the query
  • Advanced Editor

You can change the datasource from here.

Then do apply , export if necessary

Related questions

Errors when connecting oracle DB with Power BI

I am trying to use Power BI to connect with Oracle 12c Data source, I have looked for multiple solutions and followed the instruction on Microsoft documentation https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database#installing-the-oracle-client But I think there is …

Read More
Remove duplicates values based on multiple column with a condition in query editor Power BI

I am new to power bi and would require your help to sort out below issue which I am facing. Basically I am taking three columns into consideration as below: Question: I would like to remove duplicate values from above …

Read More
One Slicer for Power BI Desktop affecting multiple tables

I'm setting up multiple tables on a single Page in Power BI Desktop, with plans to publish to an App. I'm using SQL Server as a data source to pull the output of three different pre-established System Views. Each of …

Read More