Forum Discussion
direct query report from 2 databases?
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!
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
4 Replies
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 Zhanghi Anonymous 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!
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
