Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hey,
I am trying to import data using the Akamai Reporting API (https://developer.akamai.com/api/core_features/reporting/v1.html). I have an account token, client token and client secret. How can I use these credentials to access the data with PowerBI? Getting the requested data works with other tools (for example postman).
So fare I have only used "Basic" and "Organizational account" for authentication.
Best regards and thanks in advance.
I'm also doing exploration on how to integrate the Akamai API data with Microsoft Power BI in order to create an executive dashboard. Well, the issue I encounter right now is that the authentication to the Akamai API is realised with Akamai Edgegrid. I have multiple code example for OAuth2.0 but Edgegrid is a custom HTTP request signing protocol.
This specification outlines how to implement a custom HTTP request signing function in your client code.
Authenticate with EdgeGrid (akamai.com)
Example HTTP authorization header:
Authorization:EG1-HMAC-SHA256 client_token=akaa-xxxxxxxxxxxxxxxx-xxxxxxxxxxxxxxxx;
access_token=akaa-xxxxxxxxxxxxxx-xxxxxxxxxxxxxx;timestamp=20130817T02:49:13+0000;
nonce=dd9957e2-4fe5-48ca-8d32-16a772ac6d8f;signature=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
EdgeGrid authentication relies on a set of active tokens, tied to your Akamai account. First is a unique hostname that will receive your API request. Whenever you issue an API call, you need to include the authorization in the request body, then an authentication header, based on your client secret, access token, client token, and current timestamp, is generated and sent with each request.
So to integrate Akamai Edgegrid this with Power BI, one needs to create an on-premise custom data connector. Coded in M Language with Visual Studio + Power Query SDK. This could be done with Power Query but it is not safe and reliable because the code will reveal credential tokens.
Anyone has M language examples to integrate Akamai Edgegrid ?
Thank you
d4n
@PhiBu , refer if this can help
https://docs.microsoft.com/en-us/azure/active-directory/develop/quickstart-register-app
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
83 | |
67 | |
62 | |
46 | |
45 |