Forum Discussion

YashikaAgrawal's avatar
YashikaAgrawal
Post Patron
9 months ago
Solved

ODBC data sources

Hi Team,   We are working on creating Virtual machine (VM) for Power BI, gateway. Source would be SQL server and Oracle. SQL server and Oracle are in different servers.   2 questions: a. ODBC ...
Need Help
  • AnalyticPulse's avatar
    AnalyticPulse
    9 months ago

    hi YashikaAgrawal 
    use system dns as powerbi uses system dns because it is windows service. 
    you hve to create a dns in obdc connections  and test it to see if its configured successfully.(hope you know how to create it, if you search ODBC after pressing start button on your screen you will get result for 32 bit and 64 bit. use 64 bit). if you want to use direct native connectors  then you dnt need to create dns.

    when you connect in powerbi go to- get data >ODBC > select the dns you have created.

    Analytic Pulse Blog 
    Docynx Productivity Tools 
    Tool to Generate Realistic Sample Data Instantly online  

  • lbendlin's avatar
    lbendlin
    9 months ago

    a) System DSN, and only 64 bit

    b) in your connection specify the server as "dsn=<dsn name>" . Refrain from using fancy characters and spaces and overly long names, as there is a 32 character limit.

lbendlin's avatar
lbendlin
Super User
9 months ago

a) System DSN, and only 64 bit

b) in your connection specify the server as "dsn=<dsn name>" . Refrain from using fancy characters and spaces and overly long names, as there is a 32 character limit.