Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

HIVE ODBC: Can't Connect to Data Source

Hi,    I've created a report in PBI Desktop using data from a Hive table that I access using ODBC with a system DSN. I've also set up a gateway on the same server that I've used to refresh other d...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hello v-yinliw-msft,

     

    We managed to solve it by running the gateway application as a service under my own UID on our windows server.

     

    Thank you so much for the help!

v-yinliw-msft's avatar
v-yinliw-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Anonymous ,

 

This error is caused by the system DSN, please create a System DSN to points to your data source in in ODBC administrator, then add the ODBC data source under gateway. When adding a ODBC data source under gateway, make sure you enter the same connection string as that you get in Power BI Desktop.

You can refer to a similar case as follows:

Solved: Re: Personal Gateway X On Premises Gateway - Microsoft Power BI Community

 

Hope this helps you.

 

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.