How to get datasource query From PowerBI Datasets

Question

We have hundreds of datasets where one or more table has source to AnalysisService Tabular (Import mode). On Analysis Service we have set up a log (extended events), where we can find how long the query was processed.

Now I wonder how to find from which Powerbi Report/Dataset certain queries come from. That I can point the business users to change some of the bad performing queries to better ones. I can't find a way to find this.

Is there a way to do that? Can we list a dataset with queries?

Andrey Nikolov · Accepted Answer · 2021-06-30 13:10:08Z

1

No, you can't do that, or at least not exactly. One option is, if you have Power BI Premium, to use Metrics app to find the reports with highest query wait times. Another option is to you the Scanner API, which can give you the tables used in each model.

answered Jun 30, 2021 at 13:10

Andrey Nikolov

13.5k3 gold badges26 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

msta42a Over a year ago

Thanks, I haven't heard about the Scanner API, I'll check what it offers.

Collectives™ on Stack Overflow

How to get datasource query From PowerBI Datasets

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related