Dataverse Connector and Dual Storage mode | No data

[Ksven]

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

[v-cazheng-msft]

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.

[Ksven]

Hi @v-cazheng-msft ,

thanks for your reply, but unfortunately I already have known these points.

But what about behaviour when Dual table is related to Dual table ?

BR,

Sven

[v-cazheng-msft]

Hi, @Ksven 

You can this article Dual Storage Mode; The Most Important Configuration for Aggregations! Step 2 Power BI Aggregations.

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.

[Ksven]

Hi @v-cazheng-msft ,

thanks for your answer. I already have read this article before, but unfortunately there's no exact answer for Dual table to Dual table.

Have already created Microsoft Support Ticket. Actually there's no clear root cause why sometimes Data is there and sometimes not...

[v-cazheng-msft]

OK. Hope your problem can be solved. 

Best Regards,

Caiyun Zheng