[From Wrike] New Wrike Connector for Microsoft Power BI ๐
Hi Community,
Would you like to create reports and charts based on how many tasks there are in your Microsoft account? Or to see in a visual layout the statuses of all those tasks at a glance? These options and many more are now available thanks to the newly released Wrike connector of Microsoft Power BI! ๐
Note: This connector is available in the May 2023 release of Power BI Desktop and also in the Power BI Service.ย
Available for Entreprise Pinnacle accounts, the connector allows you to use Wrike as a data source for Microsoft Power BI with only a few clicks: the connector is available directly in Power BI Desktopโs Get Data options. After authenticating into Wrike through the connector, you will see three main sections to select datasets from: โAccountโ, โShared with meโ, and โSpacesโ.
You can find out further on how to pull Wrike data in Power BI in this step-by-step guide:
https://www.youtube.com/watch?v=2r1COJEcZrA&t=134s
The data objects available through the Wrike Power BI Connector include projects, tasks, custom fields, finance fields, custom item types, timelogs and many more ๐คฉ You can find the full list here.
Based on this data, you can create updated reports and multiple charts to visualize how your work is progressing. The range of charts includes bar and column charts, pie charts, doughnut, funnel and gauge charts, and also line charts, among several other options. You can also create multi cards and single cards, which you will find especially useful when needing to count a large number of tasks on your account or Space.
Already excited about the possibilities? Please, share your comments and any questions you might have below ๐
Happy reporting! ๐
Would love to try this, but isn't available for the Enterprise Standard.ย
So happy! I was just starting to play with exporting in Excel to import to Power BI. Thanks for saving me a huge step!
Thank you both for sharing your thoughts! ๐
Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa Wrike Team member Become a Wrike expert with Wrike Discover
Was direct here. I really like and produced a view but in Reports export Completed date is available when a status is complete. Is this available as would like to turn our reports into PowerBI connected refreshes.ย
We upgraded to an Enterprise tier last year to get BI Export which isn't really a clean solution.ย I can't understand how this isn't included with Enterprise Standard.ย ย
This is excellent! With this connector, would it be possible for these reports to update automatically at a fixed interval? This functionality could enable use cases where reports and charts are displayed on large screens in an office building.
Nevermind! I just read the docs: "Such published reports can also be scheduled for auto-refresh."
Thanks a lot for your feedback, folks, I'll make sure our team receives it ๐
Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa Wrike Team member Become a Wrike expert with Wrike Discover
I've been waiting for a while to see this. So happy!
I'm bummed you can't use this with the Enterprise Standard plan.
Thank you for sharing your feedback Wrike Administrator ๐
Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa Wrike Team member Become a Wrike expert with Wrike Discover
I hope Wrike considers adding this to the Enterprise Standard plan as Pinnacle is just not feasible for some businesses.
I agree with Alexus Reyes, but I'm sure it has something to do with data storage.ย
It would be nice to see a use case for downloading data to Excel in a way that would be immediately useable in Power BI.
Thank you for your feedback, folks, I'll send it to our team shortly ๐
Alexus Reyes Welcome to the Community ๐
Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa Wrike Team member Become a Wrike expert with Wrike Discover