7

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

Dee
  • 483
  • 2
  • 11
  • 24

3 Answers3

6

Workaround

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

You can change the datasource from here.

Then do apply , export if necessary

rinjan
  • 550
  • 5
  • 19
1

Like @rinjan stated above go to the advanced editor on your table in the query editor. Then you will get something like this (This is an Excel connection):

let
Source = Folder.Files("J:\TestPath"),
#"J:\TestPath\Map1 xlsx" = Source{[#"Folder Path"="J:\TestPath\",Name="Map1.xlsx"]}[Content],
#"Imported Excel" = Excel.Workbook(#"J:\TestPath\Map1 xlsx"),
Map1_Sheet = #"Imported Excel"{[Item="Map1",Kind="Sheet"]}[Data],
....and so on

Best way to go here is to copy paste the whole text into the text editor and chose the option replace all with the following line (for this example):

Old value: J:\TestPath
New value: J:\New\Path

If it is not working you have to inspect the lines of codes. Maybe you find the missing piece.

Strawberryshrub
  • 3,301
  • 2
  • 11
  • 20
  • Thanks @Strawberryshrub, I checked that and no connection details are specified there, however I can see from the actual document, it's still referencing the old source... – Attie Wagner Aug 28 '19 at 11:29
1

The first line of every table must be Source:

https://community.powerbi.com/t5/Community-Blog/Why-can-t-I-change-the-Data-Source-in-Power-BI-disabled-button/ba-p/915365

Toni Serrano
  • 11
  • 1