Forum Discussion
Direct Query - SQL - Modeling - Limitations?
Hi ACPBI - Your understanding of Power BI's limitations in DirectQuery mode and how relationships behave when working across two different servers is largely correct.
In DirectQuery mode, Power Query transformations like merging are limited because the data isn't loaded into memory but queried from the source.
If you can get approval for a linked server, the issue can be resolved by writing a SQL query that joins the two tables directly on the database side.
This ensures Power BI works with a single data source and can query it efficiently.
If possible, implement linked server . These approach simplify your data model and resolve the core limitation of cross-server joins. If those are not approved, consider combining the data into a single source via an ETL process or pre-aggregations.
Hope this helps.
Hi ACPBI - Your understanding of Power BI's limitations in DirectQuery mode and how relationships behave when working across two different servers is largely correct.
In DirectQuery mode, Power Query transformations like merging are limited because the data isn't loaded into memory but queried from the source.
If you can get approval for a linked server, the issue can be resolved by writing a SQL query that joins the two tables directly on the database side.
This ensures Power BI works with a single data source and can query it efficiently.
If possible, implement linked server . These approach simplify your data model and resolve the core limitation of cross-server joins. If those are not approved, consider combining the data into a single source via an ETL process or pre-aggregations.
Hope this helps.
Thank you for making time to reply rajendraongole1 I am discussing this with my team.
In Crystal Reports we are able to access the data using connection strings. If you can provide any insight into this option please share. Either way, yes, you have been very helpful!