How to connect Power BI to MDATP using Azure Token ID and Secret?

[bobbyvijaybs]

I'm new to Power BI, using Power BI Desktop, i am trying to connect MDATP application (i don't have access to MDATP) to connect Power BI to MDATP Firewall Alerts.

I checked for instruction in Microsoft, looks like we need to perform App Registration and generate a Token ID and Secret to connect Power BI to MDATP.

I have request Azure Tenant admin to perform app registration and he has provided me the Token ID and Secret. 

Now, using this information How can i connect Power BI Desktop to MDATP application? 

[v-yingjl]

Hi @bobbyvijaybs ,

You can connect to MDATP in power bi desktop by following the below document which introduces it in details:

Create custom reports using Power BI 

In addition, you can download the sample of MDATP from here.

Best Regards,
Yingjie Li

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

[amitchandak]

@bobbyvijaybs , see if tehse can help

https://docs.microsoft.com/en-us/power-query/handlingauthentication

https://community.powerbi.com/t5/Power-Query/Pull-data-from-a-REST-API-Authentication/td-p/246006

https://community.powerbi.com/t5/Desktop/How-to-connect-to-an-OData-source-using-a-token/td-p/116384...

https://tsmatz.wordpress.com/2017/11/02/power-bi-data-connector-sdk-oauth-tutorial/