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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
PowerBI88
Helper III
Helper III

How to embed power bi report into Dynatrace

Hi,

I would like to know if it is possible to embed a power bi report into Dynatrace. If so, how can I achieve it?

 

Thank you

Kind regards

Marta

2 REPLIES 2
v-yaningy-msft
Community Support
Community Support

Hi, @PowerBI88 

 

Based on your description, you want to know how to embed a Power BI Report into Dynatrace, but the current version of Dynatrace does not integrate directly with Power BI, but you can create a custom solution for this purpose. You need to use Power BI's Web Data Source feature to pull data from the Dynatrace API. You can try the following steps to embed a report into Dynatrace.
1. Create a Power BI report
First, create the required report in Power BI Desktop or Power BI Services. Define the Web data source in the report. Specify the Dynatrace API URL from which you want to retrieve the data (for example, the Environment API report). You can also use parameters (such as hostnames and tokens) to make the report reusable for different tenants. Make sure to set the necessary HTTP headers (e.g., "Authorization" for tokens and "Accept" for JSON data).
2. Convert data to tabular format
Since Dynatrace API responses are typically in JSON format, you need to convert the data to a tabular format. Use the Convert to Table option in Power BI to convert the data. Create columns to reference specific fields required by the report.
3. Customize Columns
Use the Add Column feature in Power BI to create columns that correspond to the relevant data fields. For example, if you want to get a list of hosts, create a column for the host name using the corresponding field in the Dynatrace API response.
4. Repeat for other queries
If you have multiple queries (for example, time series and issue API charts), repeat the above steps for each query.
5. Publish the report:
Save the Power BI report and publish it to the Power BI service.
6. Embed the report:
Open the report in the Power BI service. Go to the File menu, select Embed Report, and then select Website or Portal. You will get an embed code that can be used to integrate the report into Dynatrace.

 

Related links:

Solved: PowerBI and Dynatrace integration - Microsoft Fabric Community

https://answers.dynatrace.com/spaces/482/dynatrace-open-qa/questions/238336/dt-and-powerbi-integrati...

https://answers.dynatrace.com/questions/102159/using-microsoft-power-bi-as-big-data-storage.html

https://www.workato.com/integrations/dynatrace+powerbi

Dynatrace Notebooks Update February 2024 (youtube.com)

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Thank you for your detailed answer. 
Can you show me where to embed the code inside Dynatrace?

Thank you
kind regards

Marta

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.