Forum Discussion

Kolumam's avatar
Kolumam
Post Prodigy
7 years ago

Issue with using Dual Mode

Hi All,   I have been using both import and direct query in my desktop using a composite model that was released in this month. However, when I try to create a relationship between them, the cardin...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Kolumam,

 

1) How does dual storage works and is it same as the direct query?

Dual tables have the same constraints as DirectQuery tables. These constraints include limited M transformations and restricted DAX functions in calculated columns. For more information, see Implications of using DirectQuery.

 

2) Based on my test, it refreshes according to the scheduled refresh.

 

Regards,

Frank

  • Kolumam's avatar
    Kolumam
    Post Prodigy
    7 years ago

    If Dual storage uses schedule refresh, then I can use import for that. I am not asking for constraints, does it pull the data live?

     

    Why the hell is this feature then used for?

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      7 years ago

      Hi Kolumam,

       

      Dual tables can act as either cached or not cached, depending on the context of the query that's submitted to the Power BI dataset. In some cases, you fulfill queries from cached data. In other cases, you fulfill queries by executing an on-demand query to the data source.

       

      For more details, please check the online document.

       

      Regards,

      Frank

      • v-frfei-msft's avatar
        v-frfei-msft
        Community Support
        7 years ago

        Hi Kolumam,

         

        Does that make sense? If so, kindly mark my answer as a solution to close the case.


        Regards,
        Frank