Forum Discussion
One Hybrid table with multiple sources - KQL & BigQuery
Hi ramiouaness
Both options can be achieved in Power BI
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models
Hello Amine,
Thank you for the reply.
However, your link explains the composite model where we would have two queries, one that's in direct query and the other in import mode. What I need is for the same table to be hybrid. Meaning that the same table would take today's data in direct query from KQL and older data up til yesterday from BigQuery.
What do you mean by same Table?
You can create 2 Dataset from each source and then combine the 2 into 1 or you can merge the 2 queries in the composite dataset
I am talking about Hybrid Tables in Power BI. One table with its historical partitions imported and its current partition in Direct Query. My question is about the possibility to point the Direct Query partition to another source that is different from the imported historical partitions.
Merging queries in Power Query where one is in DQ and the other is in Import mode is not supported because merge operations from my understanding are not supported in DQ mode.No, the Hybrid Tables can only be created out of a composite model located in a workspace with premium capacity.
It is well explained in the link you sent me.