a very useful way to allow users to meet their own reporting needs.
Zen Desk is doing this very successfully.
Thanks for your reply, Venkat. It's good to hear some clear timeframes, and a recommitment to better communication. The FreshService product remains one with significant value, and it's been a great help to my organisation; I'm keen to see it get better.
I'm sure we all understand that developer time is limited, and that not all features can be delivered instantaneously - but that's also why I think a really rich integration system is of so much benefit. Rather than re-inventing the wheel, you can take advantage of work other companies are doing; this also works to make your product become an integral part of systems which your customers may be more committed to (I know my organisation is much more likely to move away from FreshService than we are to move away from Office 365 and Azure AD, for example).
Power BI integration, along with a live or nearly live update feed, would resolve two of the top four most requested features in this forum, one of which is outstanding for 4 years. It would be a big win for you and for us to see it become a reality. I'm looking forwards to seeing what you can deliver here.
Thanks for your patience & understanding. Here's how we'll address this need.
- In addition to the existing custom reports on freshservice, that can already address tickets/assets / changes reporting needs, we're building a rich reporting layer that enables:
- Reporting on Releases,Problems, Users, departments, agent groups & tasks
- Rich Interactive Visualizations with :
-- Interactive drill-downs
-- Filtering, grouping data by multiple attributes
- Custom Reporting Dashboard
-- Ability to pin reports to a dashboard to effectively monitor key performance metrics in near real-time and make informed decisions.
- Reporting across modules
-- e.g: Ability to report on tickets that are associated to changes with a high impact
We will share mocks on these later this month and we expect this to be available to customers in Q1.
For customers/prospects that still need BI level capabilities outside of these, we're considering the following options:
- Leverage a developer partner to build a powerBI integration on top of our data APIs. We're connecting with a couple of partners and should have an update for you by EOM. This will be limited by our underlying APIs, but we're constantly adding to it.
- Data on activities (either as scheduled exports or other options) across all entities that allows you to leverage powerBI or any other BI tool to build advanced reports. This will be a phased approach, but we're unable to comment on the timeframe for this yet.
We'll continue to post updates on this thread in the coming days. Pls let us know what you think.
This is why we're looking to move away from FreshService. After 2 years of asking for PowerBI integration and receiving multiple communications about how Fresh Service "has partners" or "is close" we see that FreshService is now focusing on building their own reporting tools. For those of us who have been practically begging for PowerBI, we see that we've been relegated to those customers who "still need" PowerBI integration and that FreshService is “considering the following options…”
Venkat, I’m sure you wanted to placate the barbarians at your gate who were looking for a positive and motivating communication from FreshService about PowerBI integration, but this is a swing and a miss…
One of the features with Power BI that we can create own dashboards, by manipulating data feed from Fresh service. As soon we have feed then its easy cerate look as required and publish for other departments in company. Reports that are available now "locked" for FreshService admins/tech and need to be exported first, as PDF, then sent by email.
If you give feed to Power BI, I can see live status, updates and share with company CEO/other executives, as weekly updates. And this can be combined with other metric in one dashboard which also available in mobile app. All that upper management need to do is open app at any time and see live status of various data/reports, rather then looking though email and opening attachments.
Any reports created inside Fresh service will stay there, and cant be accessed by other people in company then pretty much useless for most who don't have Freshservice "admin" account.
I can be wrong, but think it shouldn't be much development to give some access to Freshservice data though one of the Power BI supported data formats (Odata, ODBC, various SQL). Only need build connector between PowerBI and Freshservice API.
Appreciated the communication but agree with the above posts. This feature request is specifically about power bi integration. We are asking for the ability to self serve. I'm not sure what the hesitation is here as this feature makes your life easier.
Whilst I agree that your out of the box reporting needs work, it is a different use case to what people have requested on this thread.
Having a connector into fresh service data means I can create reports to show me what I want, not what you think I want. Bare minimum a scheduled export of data to an azure data location etc would work.
I'll add that this is disappointing and I will second the notion that being able to export my ticket data with some kind of schedule automatically would essentially solve this problem for me.
Still no real word on this request, I note from Venat's most recent post promises of...
We went live early October last year and I am under considerable pressure from my Senior Management Team to provide some meaninful data (ideally through Power BI) and my promises that 'Freshservice are working on it' have worn very thin.
They want dashboards created through Power Bi, we have some good examples of this working with other systems and my queue managers want similar for the job queues they are responsible for.
Please can I get an update to relay back before I present next years licencing charges for them to sign off?
IT Service Desk Manager
Dan Hollands - I user Power BI to report to my senior board. There is small element of downloading the exported data from the email I receive on request, and then overwriting the existing file in OneDrive and allowing PowerBI to refresh.
5 minutes works tops.
Ideally I would like to see this automated but it works for me. Just thought I would share!
Wayne - we currently automate the export of Ticket, requester and agent data using the API and pump into a local SQL database where we report using SSRS, though this could be linked to Power BI. This is however limited as not all data we would like to report on is available through the API.
Sorry for the delayed response.
As pointed out above, any connector built on top of Freshservice APIs are limited by the data exposed by the underlying APIs. We believe that scheduling data exports is the more scalable approach to address advanced reporting needs and the solution that will solve for the many advanced/self-serve reporting use-cases with BI tools like Tableau/PowerBI etc. We have already prioritized this feature as part of our Q2 roadmap.
In the meantime, we're currently working with a couple of developers to address the urgent need of more useful powerBI dashboards with pre-defined metrics on top of our existing APIs. This will be available on the Freshservice app marketplace. I've attached screenshots of this dashboard for your reference.
I'm also attaching mocks for our analytics solution that we're currently building into Freshservice. With Analytics in Freshservice,
- users can pin reports to a dashboard to effectively monitor service desk performance
- rich visualisations with interactive drill-downs
- reporting across all modules (tickets, tasks, problems, changes, release, groups, users, departments)
Thank you for all the inputs and please keep your feedback coming! We'll continue to update you here as we make progress on these items.
Freshservice Product Management
Thank you for sharing this progress Deepika. I really hope we can get our hands on the connector in the marketplace soon. I (and many others) would be more than happy to test and provide some preliminary feedback if you care to enable it.
That's great news Deepika, those screenshots look really good, can't wait to get my hands on it!
I'd be interested to know how often we will be able to schedule the data exports, as these will need to support live wallboards in our organisation.
Has anyone setup FS with Power BI desktop using the API? Curious?
What seems to be the hold up on the API with PowerBI integration? You have it available for Power APPS which is a newer MS offering than Power BI.