Power BI Desktop (Not Responding)

Power BI Desktop (Not Responding)Follow
Robert Stamsnijder
Robert StamsnijderNov 23, 2022 07:00 AM
Dear all, I am establishing relationships within the ISO 21378 Audit Data Collection Standard …
1. Power BI Desktop (Not Responding)

Robert Stamsnijder
Posted Nov 23, 2022 07:00 AM
Dear all,

I am establishing relationships within the ISO 21378 Audit Data Collection Standard data model. OK, it’s a bit much, 52 Primary Keys to 506 Foreign Keys, but it should be possible. However, Power BI Desktop has some trouble with it. If you only have a few relationships to establish, no problem. If you exceed a few hundred relationships and want to add some more, you will receive “Power BI Desktop (Not Responding)”. After which you drink a cup of coffee, and when you have drunk it in peace, the relationship is neatly established.

The problem is I can’t handle that much coffee. Who has a solution?

Beste groet, Best regards, Meilleures salutations, 此致，
Handtekening Robert NEN.png

2. RE: Power BI Desktop (Not Responding)

Bronze Contributor
James Watts
Posted Nov 25, 2022 04:06 AM
Don’t do it in Power BI – it can do ETLs, but it is not a heavyweight tool. Do it in SQL Server or another RDB, then build your views/queries on top.

——————————
James Watts
Business Intelligence Analyst
——————————