Updated connection method: The access token is now sent through the Authorization header instead of being included in the request URL.
Before You Start
Access to the Mentionlytics API
Your Mentionlytics account access token
Access to a Power BI workspace
Keep your access token private. Do not publish it or include it in screenshots shared outside your organization.
Connect Mentionlytics to Power BI
1. Create a new data query
Sign in to Power BI and open the workspace where you want to create your report. Select:
Create → Get Data → Blank query
2. Add the Mentionlytics API query
In the blank-query window, paste the following Power Query M code:
let token = "ACCOUNT_ACCESS_TOKEN", options = [ Headers = [ #"Authorization" = "AccessToken " & token, #"Content-Type" = "application/json" ] ], Source = Json.Document(Web.Contents(url, options)) in Source |
Replace ACCOUNT_ACCESS_TOKEN with your actual Mentionlytics access token. Keep the quotation marks around the token value.
Paste the query into the Power Query editor, then click Next.
3. Configure the connection
Click Next. When Power BI asks for credentials, select Configure connection.
Select Configure connection when the credentials prompt appears.
In the connection window:
Make sure Create new connection is selected.
Leave Authentication kind set to Anonymous. Authentication is already handled by the Authorization header in the query.
Click Connect.
Create a new web connection, keep authentication set to Anonymous, and click Connect.
4. Review and format your data
After the connection is established, Power BI displays the response returned by the Mentionlytics API. Open and expand the lists or records you need, then rename columns, set data types, and apply any transformations required for your report.
The query result appears in Power Query and can be expanded and transformed.
5. Create your report
When the data is formatted as needed, click Create a report to import your Mentionlytics data into Power BI. You can then build charts, tables, and other visualizations using the imported fields.
Refresh Your Mentionlytics Data
Refresh the Power BI data source regularly so your report includes newly collected mentions. You can refresh it manually or configure scheduled refreshes in Power BI, depending on your workspace and account settings.
Troubleshooting
Power BI asks me to sign in
Choose Anonymous as the authentication method. The Authorization header in the query handles Mentionlytics authentication.
I receive an authorization error
Confirm that you replaced ACCOUNT_ACCESS_TOKEN with the correct token, did not add extra spaces, and kept AccessToken followed by a space in the Authorization value.
No data appears
Confirm that the request completed successfully, then expand the lists or records returned in Power Query. Also check that your account has API access and that your Mentionlytics trackers contain data.
My token appeared in a shared screenshot
Treat the token as sensitive. Contact the Mentionlytics support team for guidance on replacing or securing it.