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.

Now we would like to use the same .pbix file for dashboard from SQL Azure DB by changing the connection string from Excel source to SQL azure connection string.

The Database contains exactly the same column name and table name which was used in Excel.

Could you please help? Please let us know if you need more information.

Thanks
- Sandeep

Need Help

2 Replies

  • 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