Forum Discussion

andynoodle's avatar
andynoodle
Regular Visitor
9 years ago

Direct Query - Can't use with additional data sources?

Hello,   I wish to automate a dashboard that combines data from both DocumentDB and Microsoft SQL Server.    However, if I have a documentDB connection live, I lose the option to select "Direct Q...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

andynoodle,

 

When creating a report in Power BI desktop, we can only have one connection model. Since connect to DocumentDB is using import model. So you cannot connect to your SQL Server database by using DirectQuery model. 

 

To work around this issue, you could use import model. Or you could create two reports in Power BI desktop and then publish to services. Then you can pin the visuals from two report into one dashboard.

 

Regards,

Charlie Liao

albertogastaldo's avatar
albertogastaldo
Frequent Visitor
9 years ago

Hi, is there any option to connect from Power BI to DocumentDB (now CosmosDB) in direct query mode ?
I think 99% of cases the  import mode for such (big) databases is a non-sense.

 

 

  • andynoodle's avatar
    andynoodle
    Regular Visitor
    9 years ago

    There is currently no way to do this :( hopefully soon!