Forum Discussion
How to get Database name for ODBC Datasource from Power BI
Hi, Is there any API or any DAX Query through which we can get the database name for ODBC Source type. We tried the Datasource API for Dataset and Gateway both, but in that we are not getting det...
GilbertQ
Super User
Super UserHi ekimakIA
From your screenshot the table name is below?
Otherwise what about looking at the Gateway API to get all the data sources?
You could then match the datasourceID from the GatewayAPI and match it to the above API?
I have done something similar to this in the past
Hi GilbertQ ,
We need a database name of the table for ODBC connection. Through Gateway API for datasources we are getting the same result in which it doesn't contain the database name for ODBC connection type. From DAX query, we are getting database id but we are looking for the database name for the highlighted table.