Forum Discussion

CROforce's avatar
CROforce
Icon for Helper I rankHelper I
10 years ago

Power BI - very SLOOOW

I have connected Excel file to Power BI Desktop. Excel file itself has about 10 tables and I am using formulas to get what I need in regards to calculations and stuff. My excel file is 10MB large. In...
timau's avatar
timau
Frequent Visitor
8 years ago

(Update - Nothing to do with DB Authentication.. I have added a new server to the reports; all servers having the same data structure and then merged into one table.. Some of the tables i'm importing are empty and also linked to other tables that are empty {before being merged into large table} I'm now 99% sure it's gagging on the empty tables - the timeout didnt help)

 

I have had a largish PowerBi model thats been working great for 12 months as I continue to develop it.

 

Previously i was accessing the SQL via DB Authentiation, some other staff wanted access to it so I altered the database access to AD/Windows authentication (created a group added people and all 'looked' OK after some testing)

 

Then things started timing out and generally weird REALLY slow behaviour as described above. 

 

If i refresh a table which is a consolidated table from 19 servers into one - it sits there for around 10  mins "Creating a connection in model" - then loads sucsessfully fast once that message goes away)

 

Even the local CALENDAR table generated locally now does this if I select just this one Table and refresh.

 

Is anyone else using Windows Authentication to connect to SQL server DB for Import data sources without problems?