Report integration -Power BI & Service Now

esbie
Kilo Explorer

Can we integrate Power BI reports in to Service Now reporting dashboards?

5 REPLIES 5

olgaredkina
ServiceNow Employee
ServiceNow Employee

You can add the dynamic content block widget to the dashboard with html of the report in it. You can get html (iframe) of the Power BI report from Power BI -> report -> file -> publish to web   -> html.



find_real_file.png


Then you will see the full report in the frame. Depending on the size of the report, it could be better to have it at the separate tab (see example below)


find_real_file.png


gyedwab
Mega Guru

If you're looking for enhanced reporting, you can also take a look at using Explore Analytics. It can also integrate with non-SN data in real-time, embed in the SN dashboard, and it has a much tighter integration with ServiceNow.


Alyssa Birchard
Kilo Contributor

For me, the steps in the PowerBI browser app were: File > Embed > Copy the text from the "Html you can paste into your blog or website" section. 

My copied text included "&" characters that were giving me the error:

The reference entity "<placeholder>" must end with the ";" delimiter. A little online googling told me that the error was generated because & is a special character in HTML and XML. The solution is that in the ServiceNow XML box you need to replace every occurrence of "&" with "&amp;". Then it works.   

 

Thank you for the how-to on this, @olgaredkina!

Hi The same way to how to share service now report to power Bi ?