Has anyone used Power BI to connect and display data from Spotlight?
Has anyone used Power BI to connect and display data from Spotlight?
Hi Paul,
Power BI can't be used to display Spotlight collection data. This was logged previously for consideration in the future release. At the moment, we use SSRS RDL files for reporting purposes. Our hosted app, Spotlight Cloud utilizes Power BI reports.
Gita,
Spotlight Support Team
Hello Gita,
Is it possible to embed/display a Power BI report (from Power BI Premium Capacity Metrics) in Spotlight Cloud?
Hi Karina!
Sorry didn't mean to confuse the matter. Reports of Spotlight on SQL Server Enterprise are RDL files and as you know can only be used in SSRS if you'd like to use them outside of Spotlight. You can of course parse the Select queries from these files and make your own Power BI reports. The feature of having Spotlight Enterprise reports in Power BI is an existing logged product enhancement.
We have a separate hosted application that utilizes Power BI for it's built-in reports. You can direct message me if you'd like to know more about it.
Gita
Gita,
I am assuming that you are referring to Spotlight Cloud when you say "hosted application". I have been tasked with coming up with a enterprise dashboard utilizing Spotlight data. I would love to hear more about ways to accomplish this.
Thanks
Hi Paul, we'll speak more about this on the phone and I can show you the Power BI reports of the Spotlight Cloud hosted application.
The Add Spotlights to Power BI Report isn't related to Spotlight on SQL Server Enterprise, Spotlight Cloud or any related Quest products.