Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I'm trying to configure a scheduled refresh on an SQL query for a client's databse, using the power BI on premises data gateway. I haven't gotten it to work, though, as the data source I'm specifying in the desktop version does not seem to be recognized as the data source that is included in the data gateway, despite my consistent use of the same dsn, username and password. I haven't specified any connection strings anywhere, apart from in the data gateway where I am specifying the driver used and the database location. I've taken the following steps:
I'm kind of confused by this behavior of Power BI - there seem to be a plethora of options to specify with regards to credentials and connection strings to use, and there's no way of telling whether an error like this is due to one or several of the credentials I've provided, the specific combination of drivers, an issue of version compatibilities between the desktop and web service, or the sequence of installation of the various elements in the power BI package.
My best guess at this point is that either I'm not using the proper credentials at one or more points in the process, or there's a compatibility issue caused by a prior, unreported installation of the personal gateway when the on premises data gateway should have been installed right away. As both the official support pages and the in-program help function offer little to no recourse, I'm hoping someone here can help me troubleshoot.
Bests, and many thanks in advance,
Evert
Solved! Go to Solution.
@e_a_vandoorn,
Firstly, please create a System DSN to points to your data source, then add the ODBC data source under gateway.
Secondly, follow the guide in this similar thread to add your ODBC data source within on-premises gateway, then check if you can refresh your dataset.
Regards,
@e_a_vandoorn,
Firstly, please create a System DSN to points to your data source, then add the ODBC data source under gateway.
Secondly, follow the guide in this similar thread to add your ODBC data source within on-premises gateway, then check if you can refresh your dataset.
Regards,
Many thanks! Seems like I was looking in all the wrong places.
Check out the July 2025 Power BI update to learn about new features.