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 (least labor-intensive) way to accomplish this?

Thanks!

6 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    6 years ago
    Hi there

    If I understand you want to convert your Analysis Services connections to Power BI Datasets and then use the Power BI Datasets?

    If so I do not know anyway of making this change without having to manually re-create the PBIX. You can script out the measures from Analysis Services?
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 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
      6 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.