Repeatedly asked for authentication: Analyses Services

[Enduser]

Hi,

I hope one of you can help me with a workaround so I don't have to repeatedly enter Oauth2 credentials when connecting to the Analysis Services database. Goal of the query is to retrieve the report views from the Usage Metrics Report-dataset in a list of workspaces. I am currently using a Power Automate flow to query the datasets and store the information in CSV-files, but I would like to do this via Power Query instead. Please note that I'm not an admin of the tenant, nor will I get these rights.

I have the following code:

(workspaceName as text) => 
let
    Source = AnalysisServices.Database(tokenAddress & workspaceName & "", "Usage Metrics Report", 
        [Query="
            EVALUATE#(lf)
            SUMMARIZECOLUMNS (
                'Report views'[UserId],
                'Report views'[ConsumptionMethod],
                'Report views'[CreationTime],
                'Report views'[Date],
                'Report views'[DistributionMethod],
                'Report views'[ReportId],
                'Report views'[OriginalConsumptionMethod]
            )
        "]
    )
in
    Source

I am being asked to authenticate for each workspace, even though it's the same account I use to make the connection and it's the same tenant. Since I already have 104 workspaces to monitor and additional workspaces will be added automatically, this will not be acceptable if I can't fix this.

Do you know of a way to authenticate only once with Oauth2 for all workspaces?

[lbendlin]

Never ceizes to amaze me to what lengths people go to circumvent Microsoft's rules. Very inventive.

Ask your tenant admin to share the audit logs with you instead.