direct query report from 2 databases?

[Jolyon]

Hi all,

a question about Direct Query mode:

is it possible to work in this mode with two different systems - CRM and ERP - simultaniously?

i.e. to create one Power BI Desktop-Report with direct query, having tables from these different systems?

Thank you!

[v-yuezhe-msft]

Hi @Jolyon,

It is not possible to work with two different systems in DirectQuery mode. All imported tables should come from same data source and same database in DirectQuery mode.

Thanks,
Lydia Zhang

[Jolyon]

hi @v-yuezhe-msft Lydia,

I've heard something about data warehousing. Could be a possible solution of the problem?
and is the perfomance of Power BI affected in this case?

thanks a lot!

[v-yuezhe-msft · Accepted solution]

Hi @Jolyon,

Do you want to pull data from the two systems to Azure data warehouse and then connect to Azure data warehouse from Power BI Desktop using DirectQuery mode? If that is the case, it is possible.

Additionally, to improve performance after connecting to Azure Data Warehouse through DirectQuery in Power BI Desktop, I would recommend you review the following articles to optimize Azure data warehouse design.

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-best-practices
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-statistics 



Thanks,
Lydia Zhang

[Jolyon]

Thanks @v-yuezhe-msft Lydia,

yes, I meant this way. I just didn't find the detailed information or some existing cases/topics about this possibility.

and thank you for the links)

Regards,

Jolyon