🎥 Transform Data Analysis with Microsoft Power BI and Dynatrace Grail

[GosiaMurawska]

Empower your reporting with the combined strengths of Dynatrace and Microsoft Power BI.

Join Imran Khan @imran_khan as he introduces the powerful Dynatrace Microsoft Power BI Connector for Grail. Learn how to effortlessly integrate any data from Grail into your Microsoft Power BI reports and dashboards. Whether you're working with Power BI Semantic Models, Dataflows, or Fabric (Dataflow Gen2), discover how this integration unlocks richer, more dynamic reporting.

Discover how Dynatrace Grail, the ultimate Data Lakehouse, seamlessly connects and stores all your observability data—from technical metrics like logs and traces to business insights like SLOs and user behavior. Highlights include:

• Using Dynatrace Query Language (DQL) to transform your data
• Bringing AI-driven insights into Power BI
• Exploring use cases like security monitoring, deployment overviews, log analytics, and more
  

---------------------------
📖 Chapters 📖

00:00 - Introduction
01:48 - Microsoft Power BI Integration Overview
06:40 - Dynatrace AI/LLM Observability Use Case
09:04 - Microsoft Power BI
10:25 - Dynatrace Grail DQL Connector
17:06 - Microsoft Power BI Report for AI/LLM Observability
18:07 - Threats and Exploits Use Case
19:52 - Host Deployment Tracker Use Case
21:48 - Log Analytics Use Case
24:00 - Power BI Dataflow Gen2 Use Case
28:31 - What's Next!

-----------------------------
🔗 Additional Links

Learn more about Microsoft Power BI with Dynatrace
Check out the publicly available launchpad
Try out Dynatrace with a free trial

-----------------------------
Subscribe to our YT channel 
Stay up-to-date with Dynatrace! Follow us on Facebook, Instagram, LinkedIn, Twitter, Twitch  

[AlanFoley]

Was in April 2025 version of Power BI Desktop ... removed in May 2025 update? ... why?

[imran_khan]

Hello @AlanFoley , the connector is still available. There's no plan to remove it. Can you please share a screenshot of what you see?
Thanks,
Imran

[AlanFoley]

See attached screenshots

Please download May 2025 Power BI Desktop and you will see it is no longer there

[AlanFoley]

Hi Imran

Were you able to verify?

Thanks

[imran_khan]

Hi Alan,
We checked internally and can't reproduce. We are also running the same version, 2.143.878.0 64-bit (May 2025) and still have the connector. Have you tried checking in Power BI service under dataflow? The connector is available there too. I would also suggest checking from a different workstation just to make sure.

Thanks,
Imran

[AlanFoley]

Hi Imran

Thanks for investigating

I downloaded May 2025 again - I noticed the version has changed:

Product Version: 2.143.1204.0 (25.05)+23c84aace645781dd62b8a26eb0418c7e6a84b72 (x64)

I then upgraded my Power BI Desktop on "Server1" (Prod)  and the problem still persists

However I did an upgrade on "Server2" (Dev) and I can see the Dynatrace connector there

I did also notice that the list of connectors (under Other) on Server1 is much less than on Server2 - very strange

Server1 is a production server so I will schedule a complete uninstall and reinstall

Suffice to say I think the issue may be on Server1

I am not sure if any security policies can be applied on Prod servers in our environemnt specifically related to Power BI Connectors or it is just an issue with an in-place upgrade

I will share my findings in due course

Thanks

Alan