Connect Power BI to my compliance web-based software through their API

[GEbra]

I have been attempting to connect Power BI to my compliance web-based software through their API for several days now. So can retrieve web data in Power BI, I am still encountering errors, as shown in the screenshot below. I would greatly appreciate any help or guidance on alternative methods to successfully establish this connection.

[GEbra]

@v-jianboli-msft 
Thanks alots it works...😊

[v-jianboli-msft]

Hi @GEbra ,

Not quite sure exactly what the usage requirements of your api are.

Can you call this api successfully through other tools (such as Postman)?

Maybe web.content could help you.

Here is my example:

I will use Datasets - Get Dataset In Group  API as an example:

let
//Get API Token
  tokenapiUrl = "https://login.microsoftonline.com/ecxxxxxxxx/oauth2/v2.0/token",
    body = [
          client_id="d32xxxxxx",
          grant_type="client_credentials",
          client_secret="vMfxxxxxx",
          scope="https://analysis.windows.net/powerbi/api/.default"
],

API_Response = Json.Document(Web.Contents(tokenapiUrl, [Headers = [Accept = "application/json"],
Content = Text.ToBinary(Uri.BuildQueryString(body))])),
token = API_Response[access_token],
//Get Data
apiUrl = "https://api.powerbi.com/v1.0/myorg/groups/476xxxxxxx/datasets/3a7xxxxxx",
data  = Json.Document(Web.Contents(apiUrl,[Headers=[#"Authorization"="Bearer "&token,#"Content-Type"="application/json"]]))
in
data

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GEbra]

Hi v-jianboli-msft

I am writing to seek assistance with an issue I am facing while using Power BI in conjunction with my compliance system.

I have successfully connected Power BI to my compliance system, enabling me to retrieve incident data. However, I have encountered a limitation where only 100 records are displayed per page. Regrettably, I have more than 100 records of incidents in my compliance system, and I am unable to access the additional data beyond the first page. I have attached a screenshot below to illustrate the current situation.

I would greatly appreciate it if you could provide guidance on how to modify the parameters in Power BI, allowing me to view and access the data on page two and beyond.

If there are any specific steps or settings that need to be adjusted within Power BI to retrieve and display a larger number of records per page, please provide detailed instructions. Additionally, if there are any considerations or limitations I should be aware of, kindly let me know.

[GEbra]

Hi @v-jianboli-msft 

Thank you for your prompt response, but I have limited knowledge in the field of IT. I attempted the query you provided, but I couldn't figure it out. I would like to share the documentation for the MY Compliance Management API (getpostman.com) as well as the API key. Let's assume the API key is "$22233105555A0zc555555e5ehC4K6.5555GQN3tv333455555nXl8FRz9HKVuSfS" (fake API key). I need assistance with accessing the incident data from the following URL: https://my-compliance.co.uk/api/v1/incidents. Could you please provide a step-by-step process to help me

[v-jianboli-msft · Accepted solution]

Hi @GEbra ,

Please try if this could work:

let
//Replace your real token here
token = "$22233105555A0zc555555e5ehC4K6.5555GQN3tv333455555nXl8FRz9HKVuSfS",
//Get Data
apiUrl = "https://my-compliance.co.uk/api/v1/incidents",
data  = Json.Document(Web.Contents(apiUrl,[Headers=[#"Authorization"="Bearer "&token,#"Content-Type"="application/json"]]))
in
    data

Note:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.