Forum Discussion

sheetalshettiga's avatar
sheetalshettiga
Helper IV
5 years ago
Solved

Error on apply query changes in directQuery

Hi all, I am creating a .pbix file by automation that is I am loading the metadata details to DataModelSchema and DataMashup file with metadata from json input and zipping back to .pbix. When I giv...
Need Help
Show and Tell
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi sheetalshettiga ,

     

    We can not merge tables with storage mode "DirectQuery" and from different data sources, but we can merge tables with storage mode "DirectQuery" and from the same data source.

     

    --my sample

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi sheetalshettiga ,

 

We can not merge tables with storage mode "DirectQuery" and from different data sources, but we can merge tables with storage mode "DirectQuery" and from the same data source.

 

--my sample

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.