DataConnectors
DataConnectors copied to clipboard
Data Connector SDK and samples for Power Query and Power BI
I have seen many implementations of OAuth using 'Authorization code' type using a redirect_uri, authorize_uri,token_uri. But I couldn't find any implementation using 'client_credentials' grant type using JWT tokens. Can you...
I've had no luck with OAuth so I thought I'd try Diagnostics.Trace. If I wrap the StartLogin function like so: ``` StartLogin = Diagnostics.Trace( TraceLevel.Information, "Made it here", () =>...
We have a custom connector that is using the PKCE OAuth2 flow based around the provided example [here](https://github.com/microsoft/DataConnectors/blob/5104494d70e31633235e207692c46507647ca427/samples/OAuthPKCE/PKCESample.pq) and we are having users report occasional issues where they need to...
Created a new directquery connector based on ODBC.Datasource but pretty disappointed in the limited number of expressions that get pushed down. For example I'd love it if Text.StartsWith() could be...
When I add the property SupportsStringLiterals to the list SqlCapabilities it returns me an error. SqlCapabilities = [ LimitClauseKind = LimitClauseKind.LimitOffset, PrepareStatements = true, Sql92Conformance = 8, SupportsNumericLiterals = true,...
https://docs.microsoft.com/en-us/power-query/connecting-to-graph
We produce a SQL engine with ADO.NET provider which already runs with Power BI on approximately 60 platforms such as an online accountancy product Exact Online, on which we use...
I have a custom connector that relies on the authentication kind "AAD" (Azure identities). The custom connector internally relies on a remote REST service. After an hour my AAD access...
I am currently building a custom connector using a swagger file and an OAuth flow. The OAuth flow is working fine. It asks me to login and when successful, returns...
Per `Table.GenerateByPage`'s [Helper Functions](https://docs.microsoft.com/en-us/power-query/helperfunctions#tablegeneratebypage) description, this method should call `getNextPage` until that callback returns null, then will combine all returned pages into a single table. However, when the existing `Table.GenerateByPage`...