cancel
Showing results for 
Search instead for 
Did you mean: 

Issue while deploying a hybrid table

Hello,

I am trying to deploy a hybrid table for a Power BI report via Tabular Editor, but I have an error message:

MicrosoftTeams-image (3).png

 

The table is in Import mode at the beginning. I add a DirectQuery partition via Tabular Editor.

Would anyone please help me? Thank you.

Status: Delivered

Hi @Emanresu_x ,

 

As the error information said, you might need merge or delete partitions.

For best performance, drop all imported dimension tables that relate to the large fact table, reimport them in DirectQuery, and then change their storage mode to Dual. That’s because currently Power BI Desktop doesn’t let you switch from Import to DirectQuery and there is no workaround.

 

Create Hybrid Tables with Tabular Editor for Power BI? YES!!! - Guy in a Cube

Power BI Hybrid Tables – Prologika

 

Best regards.
Community Support Team_ Caitlyn

 

Comments
v-caitlyn-mstf
Community Support
Status changed to: Delivered

Hi @Emanresu_x ,

 

As the error information said, you might need merge or delete partitions.

For best performance, drop all imported dimension tables that relate to the large fact table, reimport them in DirectQuery, and then change their storage mode to Dual. That’s because currently Power BI Desktop doesn’t let you switch from Import to DirectQuery and there is no workaround.

 

Create Hybrid Tables with Tabular Editor for Power BI? YES!!! - Guy in a Cube

Power BI Hybrid Tables – Prologika

 

Best regards.
Community Support Team_ Caitlyn

 

Emanresu_x
Regular Visitor

Hi @v-caitlyn-mstf , thank you for your feedback.

I haven't yet found a way to set the storage mode to dual for data coming from Azure Dadatabrick. Because once I use the SQL query to fetch the data, the storage mode is imported by default.