Forum Discussion

ramiouaness's avatar
ramiouaness
Frequent Visitor
2 years ago

One Hybrid table with multiple sources - KQL & BigQuery

Hello, Let me start by saying that I'm putting this question under Power BI Service Forum, but I'm not sure if it's the right place for it. I have a requirement where data needs to be read in r...
Dataflow
Need Help
aj1973's avatar
aj1973
Community Champion
2 years ago

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

ramiouaness's avatar
ramiouaness
Frequent Visitor
2 years ago

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.

  • aj1973's avatar
    aj1973
    Community Champion
    2 years ago

    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.