Forum Discussion
direct query report from 2 databases?
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
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
hi 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 ZhangThanks Anonymous 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