Forum Discussion
Data source connection
Hey
I have just downloaded MicrosoftDefenderForEndpoint-PowerBI/Administration and Management at master · microsoft/MicrosoftDefenderForEndpoint-PowerBI · GitHub pbix file.
It works fine in PowerBI Desktop when using my own credentials.
But how do I setup data source credentials? (I have create an application in Azure)
(Using this in another powershell script)
$tenantId = 'xxxxx'
$appId = 'xxxxx'
$appSecret = 'xxxxx'
$resourceAppIdUri = 'https://api.securitycenter.windows.com'
$oAuthUri = "https://login.windows.net/$TenantId/oauth2/token"
With Variables I mean the values are in the code writen. You can use "parameters" that will need to write it at Service or it's just another step at the power query code. You can have steps like
tenantId = 'xxxxx'
appId = 'xxxxx'
appSecret = 'xxxxx'
resourceAppIdUri = 'https://api.securitycenter.windows.com'
oAuthUri = "https://login.windows.net/$TenantId/oauth2/token"If you have a Web.Contests with all those values in the request login and getting the data with only code, then it's an anonymous auth because the code is already doing it all.
I hope that make sense
3 Replies
Hi. If your web source is an endpoint and you have all those values as variables setting headers in the code. Then there is nothing else than anonymous to continue because you are handling the auth in the code. I have used that one to connect to some Azure services and it worked good.
I hope that helps,
But how do I add the variables to a dataset?
With Variables I mean the values are in the code writen. You can use "parameters" that will need to write it at Service or it's just another step at the power query code. You can have steps like
tenantId = 'xxxxx'
appId = 'xxxxx'
appSecret = 'xxxxx'
resourceAppIdUri = 'https://api.securitycenter.windows.com'
oAuthUri = "https://login.windows.net/$TenantId/oauth2/token"If you have a Web.Contests with all those values in the request login and getting the data with only code, then it's an anonymous auth because the code is already doing it all.
I hope that make sense
