cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Akahn Member
Member

"Detecting relationships..." is taking forever

I've got a query from a Azure SQL database of about 650 K records with maybe 20 columns. The load has already taken about 40 minutes and seems to be stuck on "Detecting relationships". Any ideas what is happening?

2 REPLIES 2
Power BI Team LanceDelano
Power BI Team

Re: "Detecting relationships..." is taking forever

Hi, can you send us a copy of the schema?  How many tables, what relationships?  Does the problem still exist?

 

Lance
edwardm9 New Member
New Member

Re: "Detecting relationships..." is taking forever

Did anyone find asolution to this problem?  I have the same issue.  Using PowerBI Desktop I am connecting to a SQL instance to load a DB.  PowerBI Desktop is on the same server as the SQL instance.  Server is Windows 2016 Server, SQL is 2016, PowerBI is January 2018 build, SQL DB compatibiility version is 2008.  Server has 4 vCPU which never go above 60% and 24 GB RAM which gets pegged by Analysis services during the detecting relationships step.  Detecting relationships was running for over 12 hours on the first load.  I think it is a fairly simple DB (QuoteWerks is the app).  Any help is greatly appreciated.  Thanks!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 263 members 2,767 guests
Please welcome our newest community members: