Close ODBC connection after running query
I'm running into frequent ODBC errors saying I'm running into a session limit, but this happens even if it's the first thing I do in the morning after a full reboot. I heard somewhere that Power BI might not close the connection after running the query, which is my best guess as to why I keep enc...
Resume load for other tables if one has an error
It's really annoying to wait for an hour for a bunch of queries to refresh only for an '#N/A' value in an excel table cause the entire load to crash. There should be a prompt that asks if you want to continue refreshing other tables that aren't tied to the one with the error, avoiding the need to...
Don't cancel refresh for all tables if one refresh fails
It is very irritating to wait for over an hour for a report to refresh, only to have every single table's upload cancelled out because one table failed. I frequently have to work with Excel files on a shared source, as well as a variety of Oracle SQL and SQL Server databases. This causes probl...