Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Jolyon
Helper III
Helper III

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!

1 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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-yuezhe-msft
Employee
Employee

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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!

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors