Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.