cancel
Showing results for 
Search instead for 
Did you mean: 

PowerBI freezes when creating a relationship with a date table in DirectQuery mode Snowflake

PowerBI freezes when creating a relationship with a date table in DirectQuery mode Snowflake

PowerBI direct Query Snowflake Date table relation freeze

Please help this is urgent

I used the import function next and that works, but I need to use direct query so the workaround is not good for this case

Thanks

 

Status: New
Comments
Moderator

Hi @johannes_botha

 

Please update Power BI desktop to the latest version 2.68.5432.841 64-bit (April 2019) then test again. 

 

When you create a relationship, please click on Manage Relationships to create a new relationship. 

 

q1.PNG

 

If the issue still occurs, I would suggest you create a support ticket to get help. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu 

sp8 Regular Visitor
Regular Visitor

I have the same issue. I'm using the June 2019 version and when I try creating relationships via manage or via drag-and-drop it freezes and I have the shut down Power BI via task manager.

I'm using direct query to a SAP Hana data source with too many rows to be reasonable in Import mode.

Any ideas?

Frequent Visitor

I'm facing to the same problem. My datasource is an oracle database via DirectQuery. 

After loading all tables Power BI get freezed during connecting the tables. 

 

Still no solution for this issue? 

 

Edit: Forgot to mention --> I've installed the latest version. didn't help !