Can not refresh ODBC dataset on Power Bi service

[jaypatel]

Hi,

I have published one report to Power bi service but unable to refresh the dataset. 

It throws me some error attached below.

Something went wrong
Unable to connect to the data source undefined.
Please try again later or contact support. If you contact support, please provide these details.
Underlying error code: -2147467259
Underlying error message: ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind: Odbc
Microsoft.Data.Mashup.ValueError.DataSourcePath: dsn=Cloudbreak_64_Binary
Microsoft.Data.Mashup.ValueError.OdbcErrors: #table({"SQLState", "NativeError", "Message"}, {})
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error
Cluster URI: WABI-US-EAST2-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 4bf5ba3e-179e-4e17-aa48-e0e238716f23
Request ID: d34b079b-fb9d-916b-3f1d-de6edf5fcb7d
Time: 2020-09-15 14:37:27Z

Thanks,

Jay

[Greg_Deckler]

@jaypatel Is the ODBC connection defined on your gateway?

Otherwise, You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[jaypatel]

@Greg_Deckler 

@amitchandak 

Yes, My connection has established successfully. And gateway is perfect running on the server. 

Gateway connection:

But when I refresh dataset it throws me below error.

P.S.: I have just changed the DSN name. Which I had asked in question and reply in this answer are the same gateway connection.

Thanks,

Jay

[Greg_Deckler]

@jaypatel But is your ODBC data source defined on the gateway? That's the question. And, is it defined correctly in the 64-bit and not the 32-bit?

[jaypatel]

@Greg_Deckler 

Thanks for your response.

Yes I have configured ODBC driver with my server credentials. And I have tried with both bit of version i.e. 32-bit and 64-bit.

[Greg_Deckler]

@jaypatel I think you are in support territory. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[amitchandak]

@jaypatel , is your gateway working properly

See if these can help if that is not working properly

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/