Forum Discussion
Progress ODBC database issues
peeyushp ODBC connections for data refresh via gateway is already supported so this shouldn't be an issue. Have you tried creating DSN for your data source and using that instead straight using ODBC connection string to connect.
ankitpatira The problem is I'm not able to do a manual refresh from Power BI desktop for my reports which I have created on the Desktop version. I have setup a Personal gateway for scheduled refreshes, but I suppose if the manual refresh itself is not working then automatic refresh via gateway is out of question.
peeyushp Perhaps to pinpoint where the issue is via query editor limit the number of rows returned. If it works then you know refreshing million+ rows is the issue. Why it worked for input and not refresh can be the next piece of puzzle.
ankitpatira I spoke to our company's database administrator about this and he says that Power BI logs in using the driver, creates a connection but does not disconnect. In subsequent refreshes, the server runs out of connections (because the previous connections have not been terminated), and hence rejects further connections.
Is there a setting in Power BI where I can change this? so that it disconnects after refresh?
