Forum Discussion

Sandeep's avatar
Sandeep
Helper I
10 years ago

Changing connection for pbix file from excel to SQL Azure

HI Team, We have created few dashboards using existing Excel file. Now as a part of long term strategy we have uploaded the excel data into SQL Azure and automated the process of data refresh. ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

You best bet is to use Advanced Editor in the Desktop. View | Advanced Editor.

 

What I would recommend would be to backup your PBIX file (obviously). Create a new PBIX file and createa a query to to Azure SQL DB for a particularly table. In Query Editor, go to View | Advanced Editor and look at the "Source" line:

 

    Source = Csv.Document(File.Contents("C:\temp\powerbi\pivot.csv"),[Delimiter=",", Encoding=1252]),

That one is for a CSV file. Copy the entire Source line.

 

Now, go into your original PBIX, edit the corresponding query in it, View | Advanced Editor and replace its source line with the one you copied. Save.

 

If everything is the same (big if) then it should work seamlessly.

 

 

  • Sandeep's avatar
    Sandeep
    Helper I
    10 years ago
    Thanks..

    I already tried this way but seems it's not working.. I have already replied the to a post on a different thread..

    Thanks,
    Sandeep