Forum Discussion

sean_browning's avatar
sean_browning
New Member
6 years ago
Solved

Power BI Dataset Live Connect, Convert from SSAS Live Connect

We have a lot of reports with Analysis Services Live Connections. We would like to convert these to Power BI Dataset Live Connections. I can not find a way to do this via the UI. What is the easiest...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi sean_browning ,

Sorry, I am not sure about your requirement...Do you want to connect to Analysis service via Power BI Datasets?

1. Publish pbix(Analysis service with Live Connection ) to service.

2. In Desktop, click "Get data" --> Power BI Datasets

 

Best regards,

Eyelyn Qin

sean_browning's avatar
sean_browning
New Member
5 years ago

Evelyn,

 

We are able to do that for new files, but when there is an existing PBIX file with a Live Connection to Analysis Services, I don't know how to convert that file to have a Live Connection to Power BI Dataset.

 

My goal

 

Existing PBIX with Live SSAS Connection >> PBIX with Live PBI Dataset Connection

 

So far, I do not see a simple method to make this happen.

    • sean_browning's avatar
      sean_browning
      New Member
      5 years ago

      Excellent suggestion on tool from PowerBITips.com. I followed the code and found the steps are:

      1. Add .zip to the file and open in File Explorer

      2. Delete "Connections" and "Security Bindings" files in the zip archive.

      3. Remove the .zip extension and open PBIX file as normal.

      4. Choose Get Data from Power BI Dataset (Live)

      • GilbertQ's avatar
        GilbertQ
        Super User
        5 years ago
        Whilst this does work, remember if something goes wrong it is not supported my Microsoft.