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?
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!