Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Msta
Helper I
Helper I

Find all queries to azure AS from PowerBI

I have found this article:

 

https://www.kasperonbi.com/find-all-queries-to-azure-as-from-a-power-bi-report-or-dataset/?unapprove...

 

When I run this query ApplicationContext_s return blank:

AzureDiagnostics
| where OperationName == "QueryBegin"
| project TimeGenerated, TextData_s, DatabaseName_s, ApplicationContext_s
| where TimeGenerated > ago(2h)

But this not work for my AS model Compatibility Level 1500 (i have one with Compatibility level = 1400 where ApplicationContext_s return dataset_id as expected).

Is there a way to get this information for Level 1500? Some AS advanced settings? Or something inside powerbi?

2 REPLIES 2
Msta
Helper I
Helper I

There is no word on what I am asking. I want to find out if it is possible to obtain information on which data package / report from powerbi generated a specific query (as in the previously mentioned article).

v-henryk-mstf
Community Support
Community Support

Hi @Msta ,

 

Check if this document can help you:

Analysis Services Adventure Works Internet Sales tutorial (1500) | Microsoft Docs

Compatibility level for tabular models in Analysis Services | Microsoft Docs

Power BI as a superset of Azure Analysis Services | Microsoft Power BI Blog | Microsoft Power BI


Best Regards,
Henry

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors