Forum Discussion

Ksven's avatar
Ksven
Icon for Advocate III rankAdvocate III
5 years ago

Dataverse Connector and Dual Storage mode | No data

Hi lovely community,

 

currently I've recognized some strange behaviour.

I've connected my Report with standard table in dataverse "account" via Dataverse Connector.

 

I've just renamed columns (about 7) in power query, so nothing special.

 

Direct Query mode:

-> Works fine, but I would like to use Dual modus, cause of some other table in Import mode

 

Dual mode: 

-> FIRST 2-5 times of refresh worked fine, but now (even in Power BI service) theres no change to get the data of my account table again.

 

Checking my Power Query incl. refresh, everything works fine here:

 

 

After "Close & Apply", Data table contains no data and I'cant work with the table:

 

Somebody knows what happened here? Or already has an solution?

 

Already tried:

- Delete and create new -> First times of refresh works, then the same problem

- Deleting Cache -> Still the same

 

I'm using also standard table "contact" in Dual mode, here everything works fine.

 

BR,

Sven

Need Help

5 Replies

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Ksven 

    Dual Storage can act as either cached or not cached, which depending on the context of the query submitted to the  dataset. If Dual tables acts as DirectQuery tables, data will not be loaded in Power BI. If Dual tables acts as Import tables, data will be loaded into Power BI. For more details about Dual Storage, you can refer Manage storage mode in Power BI Desktop.In addition, the option ‘Enable load’ will affect data load. And the connection stability will affect data load as well.

     

     

    Best Regards,

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.