Start a new topic

Microsoft Power BI intigration

a very useful way to allow users to meet their own reporting needs.


Zen Desk is doing this very successfully.


Curtis


46 people like this idea

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.


1 person likes this

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. 


1 person likes this

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…


3 people like this
Hi Venkat,

Once again, I find myself severely disappointed in FreshService's response.  You can build up your reporting module forever but, I promise, you won't be able to match the reporting capabilities of a true BI tool.  I'm not sure you all understand that this isn't just about reporting capability either. A dedicated BI tool provides a single page for management and employees to report on all IT metrics.  You will never be able to provide a single dashboard that contains everything management or employees want to see.  ITIL and ITSM tools with top notch reporting capability still provide Power BI connectors (ZenDesk & ServiceNow).

I've said it multiple times to multiple CAMs and I've said it in this thread.  If you gave us the ability to export all of our ticket data on a schedule, I wouldn't need a Power BI Connector...

I'm in complete agreement with Michael - "swing and a miss".  I don't think your response is what any of us were hoping or looking for. 

 


5 people like this

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. 


4 people like this

Hi Venkat, 


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.


Rob


6 people like this

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.


5 people like this

Still no real word on this request, I note from Venat's most recent post promises of...


  1. Sharing mock ups? Not seen those
  2. Continuing to post updates on this thread in the coming days? Not seen any?


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?


Thanks

Dan Hollands

IT Service Desk Manager

Stockport Council




2 people like this

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.

Hello all,


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. 


Deepikaa

Freshservice Product Management 


5 people like this

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. 


Thanks again.

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.


Has anyone successfully setup FS with Power BI desktop? Using the API?

Deepika, why did FS choose to create a link to the newer service PowerApps when it is clear your customers wanted Power BI?

 

Login or Signup to post a comment
JS Bin