How do I make a Domo to Power BI Connection with Microsoft Authentication or Okta SSO and not ROPC?

Trentrichens
Trentrichens Member
in Connectors

Using the connector on the left requires an ROPC verification type which asks for the users Password. Our security requires that we work through a redirect with SSO and a token is passed back so passwords are only entered in one area. I believe the MSAL connector on the right should fill that criteria but it is still asking for a user id and password on the initial connector form. Using my personal credentials I get an error despite being in the Azure group and having the privileges/rights assigned. I don't have SSO enable currently for my Domo instance which may be at least one of the problems. The other, is perhaps I shouldn't be using my person credentials but rather a service account. Has anyone come across this and found a resolution or a better method to connect Domo to PowerBI for those stuck on the Micro-verse world?

image.png

image.png
image.png
Tagged:

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    ODBC stands for Open Database Connectivity, simply put, it's a connection or handshake between systems. You may have several, some for source and others for destinations or both.

    I have data coming into Domo through Workbench, Python, and APIs. And I have data displayed in Domo and some other data routed out to Power BI, MS SQL, Azure, and Excel csv files.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ArborRose
    ArborRose Coach

    I don't know about the path you are seeking. But, are you aware there is a Domo ODBC connector that can connect you to your Power BI? Our Finance team uses Power BI and we use the ODBC to source our Domo data via their Power BI dashboards.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • Trentrichens
    Trentrichens Member

    @ArborRose, thank you, I'm somewhat familiar with it and I sent it back to our engineering team to have them explore it more. There actually three ODBC connectors. One for Amazon Redshift, one for OASIS Rest API, and another for Domo Workbench(also Windows Server or .NET Framework). I'm hoping they can make one of those work relatively easily. Workbench is on prem which is definitely not the direction we want to go. Cloud, Cloud, Cloud is the mantra I'm told.

  • ArborRose
    ArborRose Coach
    Answer ✓

    ODBC stands for Open Database Connectivity, simply put, it's a connection or handshake between systems. You may have several, some for source and others for destinations or both.

    I have data coming into Domo through Workbench, Python, and APIs. And I have data displayed in Domo and some other data routed out to Power BI, MS SQL, Azure, and Excel csv files.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • calvert_schaefer
    calvert_schaefer Member

    @ArborRose How did you go about enabling scheduled refresh in PowerBI so the data from Domo via the ODBC stays up to date ? We are currently trying to install a gateway but running into issues.

  • ArborRose
    ArborRose Coach

    @calvert_schaefer - I previously mentioned our Finance team uses Power BI. I helped them get ODBC configured to connect with Domo, they handle their own Power BI refresh.

    • Set Up the Domo ODBC Connection on the Gateway Machine:
      • Install the Domo ODBC driver on the same machine where the gateway is installed.
      • Configure the DSN (Data Source Name) in the ODBC Data Source Administrator. Use the same DSN name in Power BI when connecting to Domo.
    • Connect to Domo from Power BI:
      • In Power BI Desktop, use Get Data > ODBC and select the DSN you configured for Domo.
      • Build your report and publish it to the Power BI Service.
    • Configure the Gateway in Power BI Service:
      • In Power BI Service, go to Settings > Data Sources.
      • Add a new data source using the same DSN name and credentials.
      • Ensure the Gateway Connection is set to the installed gateway and that it’s online.
    • Enable Scheduled Refresh:
      • In the dataset settings for the Power BI report, turn on Scheduled Refresh.
      • Set the desired frequency and times for the refresh.


    Google "Power BI scheduled refresh" - there are many Microsoft sites on the topic.

    Note - the Domo ODBC is apparently limited to a million records. Which is a problem for many companies with anything other than aggregated data. Thus Domo recommends the Power BI MSAL Writeback Connector.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories