Forum Discussion
PowerBI Desktop Refresh - timeout or fails, or SLOW
I use DAX heavily in places, so direct query is not the best option. Also, hundreds of peple will access these reports on a daily basis, our Data Warehouse could not handle the traffic.
Desktop machine is i5 1.7 with 8gigs of ram. Not a bad little machine.
No other processes running (well, occasionally IE11 is running to update refresh stuff for other files in PowerBI), this machine is ONLY for PowerBI Desktop. I remote desktop connect to it from my other production machine. This machine is logged in with a services account. This makes publishing reports much easier and they are associated with this services account, and not my email address..
Other ideas?
Hi kenab
Are you by any chance using any Power Query/M in your queries?
Are you doing any merges, filters or anything like that ahead of doing your DAX?
I've found that if you are doing anything other than selecting a table in the Query Editor it causes timeouts, fails, and just general slowness so I now avoid doing anything to shape the data in the query editor first.
+1 ianbarker - Good points!