Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Connect to sql

Hi team, 

 

I have one Power bi file currently  connected to afew sources (live connection with salesforce, & some connect to sharepoint). 

I would like to add one sql source to link to the data model that i currently have. However, when i select get data > SQL Server Analysis Services database, i am not given a choice to connect " Direct Query"  or" Connect live", may i know what's wrong here? why am i only get to choose import?

Thanks in advance !

Need Help
Tips and Tricks
Tutorial Requests
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Anonymous 

    You seem to be trying to create a composite model mentioned in this thread Using DirectQuery for Power BI datasets and Azure Analysis Services (preview) 

    If so, you need to be aware that using DirectQuery for Power BI datasets and Azure Analysis Services requires your report to have a local model. So when you can start from a live connection you need add or upgrade to a local model. You can also start with a DirectQuery connection or imported data, which automatically creates a local model in your report, but currently SSAS can't be using as directquery source.
    considerations-and-limitations 

    In fact, live Connection is only supporting one source for the connection. If you want to have more than one source for this connection, then you need to bring them all into the live connection datasource model rather than in PowerBI. 

     

    Best Regards,
    Community Support Team _ Eason

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , is there anything already added to this file ?

    If yes, in the new file try first start with Analysis service and then try to add other content , then it should give option to convert to direct query

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Yes, i currently have other thing connected with other datasource mentioned above. Couldnt it continue from there? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi, 

       

      Even if i start first with the Sql connection , after connected to the sql, it doesnt allow me to connect to other datasource already. May i know do you have other solution for this? Thanks!

       

       

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        4 years ago

        Hi, Anonymous 

        You seem to be trying to create a composite model mentioned in this thread Using DirectQuery for Power BI datasets and Azure Analysis Services (preview) 

        If so, you need to be aware that using DirectQuery for Power BI datasets and Azure Analysis Services requires your report to have a local model. So when you can start from a live connection you need add or upgrade to a local model. You can also start with a DirectQuery connection or imported data, which automatically creates a local model in your report, but currently SSAS can't be using as directquery source.
        considerations-and-limitations 

        In fact, live Connection is only supporting one source for the connection. If you want to have more than one source for this connection, then you need to bring them all into the live connection datasource model rather than in PowerBI. 

         

        Best Regards,
        Community Support Team _ Eason