Here's a sample custom connector for the DataWorld API, which also uses OAuth 2.0 authentication with an authorization code grant type. If you start down this path, I'm more than happy to help you through it. Note: if you've not created a custom connector before, you'll need to read and understand the prerequisites first. In other words, the flow to authenticate to both the GitHub and Zoho APIs are similar. And once you get the hang of that, it's not that challenging to swap out the GitHub authentication parameters with Zoho parameters. Luckily, this GitHub custom connector tutorial walks you through the basics. If you're not familiar with custom connectors, particularly those that authenticate with OAuth 2.0, prepare to spend a few days or even weeks figuring it out. With Zoho products, you just need to call the API with Web.Contents.
#Power bi desktop login driver
Shared ZohoDesk.Contents = () => GetDirectory() Īuthentication=]Įlizabeth - You don't need an ODBC driver to connect the custom connector. Refresh = (resourceUrl, refresh_token) => TokenMethod(refresh_token, "refresh_token") Table = Table.FromList(json, Splitter.SplitByNothing(), null, null, ExtraValues.Error) TokenMethod(Parts, "authorization_code") Redirect_uri = client_application])ĬallbackUri = client_application,įinishLogin = (Context, CallbackUri, state) => StartLogin = (resourceUrl, state, display) =>ĪuthorizeUrl = "" & Uri.BuildQueryString([ This file contains your Data Connector logicīuttonText = Ĭlient_application = Expression.Evaluate(Text.FromBinary(Extension.Contents("client_application"))) Ĭontent = Text.ToBinary(Uri.BuildQueryString([Ĭlient_id = client_application,Ĭlient_secret = client_application, Any ideas what I could be doing wrong ? Regards, I am stuck getting Login Failed, can't parse Query String. Hello Tony, I went down this path using the DropBox example as an example, and I paste below what I have. How long did it take you to develop the custom connector? Will I need an ODBC driver to connect the custom connector with Power BI desktop.
#Power bi desktop login how to
Subject: Zoho Desk connector to Power BI desktopĪny ideas on how to connect Zoho Desk to Power bi Desktop? Not the same as Zoho CRM.īusiness Intelligence Dashboards Developer Let me know if you run into any problems I'm happy to help. You can use these examples as templates for your Power BI custom connector to Zoho Desk. (Both examples were created by developers on the Power BI product team.) This other custom connector connects to Dropbox, which again, also uses OAuth 2.0 with the same grant type. And these APIs implement the "authorization code" grant type, which is a way for your application to request tokens from the authorization server. I quickly looked at the API documentation for Zoho Desk and that API authenticates the same way as other Zoho products. My company uses Zoho products and I've built custom connectors in both Flow and Power BI to our data in Zoho Books, Zoho CRM, and Zoho Campaigns. This means you'll have to build a custom connector in Power BI. Elizabeth - Zoho products allow applications to authenticate to their APIs using OAuth 2.0.
0 kommentar(er)
