Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am a newbie with Power BI, I'm trying to setup a custom connector but it's being quite a challenge so far, my aim is to first authenticate to the API and then retrieve reports, but I am getting a "The name DataWorldSwagger.Contents wasn't recongnised" error.
Here is the code:
query.pq
let
result = DataWorldSwagger.Contents()
in
result
pq
// This file contains your Data Connector logic
section DataWorldSwagger;
[DataSource.Kind="DataWorldSwagger", Publish="DataWorldSwagger.Publish"]
shared DataWorldSwagger.Contents = () =>
let
token = TokenMethod(),
// get reports
Data2 = Web.Contents("https://xxx:8002/v1/reports",[Headers=[#"Authorization" = "Bearer " & token,#"Content-type" = "application/x-www-form-urlencoded",#"Accept" = "application/json"]]),
DataRecord = Json.Document(Data2),
//token = Json.Document(Data)[token],
Source= DataRecord
in
Source;
// Data Source Kind description
DataWorldSwagger = [
TestConnection = (dataSourcePath) => { "DataWorldSwagger.Contents", dataSourcePath },
Authentication = [
Anonymous = []
],
Label = Extension.LoadString("DataSourceLabel")
];
// Data Source UI publishing description
DataWorldSwagger.Publish = [
Beta = true,
Category = "Other",
ButtonText = { Extension.LoadString("ButtonTitle"), Extension.LoadString("ButtonHelp") },
];
TokenMethod = () =>
let
// get token
body = "username=admin&password=xxx",
Data= Web.Contents("https://xxx:8002/v1/auth/token?app=",[Content=Text.ToBinary(body),Headers=[#"Content-type" = "application/x-www-form-urlencoded",#"Accept" = "application/json"]]),
//DataRecord = Json.Document(Data),
token = Json.Document(Data)[token],
Source= token
in
Source;
All help is appreciated,
Thank you in advance,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |