Following a post I found on how to do this, I immediately encountered the Formula Firewall issue. Even when using the template linked in the blog post. I wonder if something has changed in PowerBI?
Post here: https://prathy.com/2018/02/powerbi-audit-log-using-office365-management-api/
I started from scratch and determined the first instance of the firewall issue. When referencing the access token provided from:
https://login.windows.net/common/oauth2/token
in my query to the api:
https://manage.office.com/api/v1.0/MYTENANTDOMAIN.onmicrosoft.com/activity/feed/subscriptions/conten...
PowerBI gives me the formula firewall issue.
This is what I have to call the Management API (NOTE: the accessToken is directly from post above and does return a token)
let
Source = Json.Document(
Web.Contents(
"https://manage.office.com/api/v1.0/MYTENANTDOMAIN.onmicrosoft.com/activity/feed/subscriptions/content?contentType=Audit.SharePoint",
[
Headers = [
Authorization="Bearer "&accessToken&""
]
]
)
)
in
Source
Just to test the query, I went to Postman and got an access token, pasted in place of "accessToken," and PowerBI connected. What I'm not getting here is why using this pattern hits the firewall and is there a way to get around it?
