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 m...
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

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

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