What can we help you with?

e.g. Gantt chart, Creating tasks, Sharing folders

Anyone using 3rd party or external reporting tools on Wrike data

12 comments

  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Pavel M

    Hi Scott! Your suggestion about MS tools, such as Excel and Power BI, came just in time. It is indeed possible to integrate them with Wrike's API directly, to avoid the step of exporting to XLS.

    In regards to this, I soon plan to post a short guide related to the usage of the Power Query (this is the script language used in Excel & Power BI and based on the M-language). By the way, do you personally or anyone on your team have any experience in linking RESTfulย API's with theย ETL or database tools you use? Would love to hear your story!

    Pavel M Community Team at Wrike ๐ŸŒŽDiscover... Wrike Discover and become a Wrike expert. Click here to get started

    Is this helpful? 0
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Scott Grothaus

    Don't have a story today, but looking forward to using your guide to create one.

    Is this helpful? 0
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Paul Bushrow

    We are using Power BI with our Wrike data to augment the reporting capabilities of Wrike. ย We are definitely looking forward to your hearing more about linking the tools more directly (we currently export timelog data to Excel and then run the PowerBI transform from there).

    ย 

    Is this helpful? 0
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Pavel M

    Hi Paul! Sounds great, I was actually planning to cover Timelogs in my example, still working on the post, hope to publish it soon. Stay tuned!ย 

    Pavel M Community Team at Wrike ๐ŸŒŽDiscover... Wrike Discover and become a Wrike expert. Click here to get started

    Is this helpful? 1
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Paul Bushrow

    Great to hear -- one of our friction points is decomposing the folder structure to group items at a common level. ย The mulitple tag feature complicates things (we only get the first one, which is alphabetical, since the potential variations are numerous), but also the flexibility of the folder structure makes it more challenging to transform that field in a consistent way. ย To elaborate -- we are trying to capture the timelog hours against a specific project, and ย we parse out the folder string and have to designate which level of the string (levels separated by /) is the right one (the top level for that particular project) for grouping. ย Our approach to limiting variability in the string (through naming conventions and SOP/governance) has impacted our flexibility in using folders and projects. ย So addressing a use case that allows me to more easily and dependably identify and extract the desired level from the string would be very helpful.

    Is this helpful? 0
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Jeff Hampson

    Adding interest toย utilizing Power BI, looking forward to seeing this guide. Thanks

    Is this helpful? 0
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Jurgen Koolen

    I'm also eager to see this guide. It would be very useful to link excel directly with Wrike to get the timelogs data, instead of having to do an export every week. Thanks!

    Is this helpful? 0
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Scott Grothaus

    Can we get an update as to when this guide will be released? I was hoping to see something by now as we could really use it.

    Is this helpful? 0
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Pavel M

    Hi everyone! I have just posted the promised article, here it is: Connecting Wrike's API with MS Excel and Power BI. Will be happy to answer your questions! In case you have some suggestions or want to share your Power Query experience - you are welcome to leave comments. I plan to post more specific tutorials in continuation of the topic if this post is helpful.

    Pavel M Community Team at Wrike ๐ŸŒŽDiscover... Wrike Discover and become a Wrike expert. Click here to get started

    Is this helpful? 0
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Andrew Syme

    Were there any solutions found for making a direct link to Power BI? I keep getting an expression error like this:

    Expression.Error: The 'Authorization' header is only supported when connection anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Referer.

    ย 

    I'd love to get this running.

    Is this helpful? 0
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Serge S

    Hey everyone! Iโ€™m happy to announce the availability of BI Export beta for all Enterprise accounts! BI Export allows us to extract the data from Wrike in BI-friendly way via API. We canโ€™t activate the beta from here so if youโ€™re interested in the functionality please reach out to your Customer Success Manager for activation. ๐Ÿ˜€

    @Andrew, so sorry we missed your message! This looks like an issue with Power BI Integration Utility. From what I was able to find online we can try the following: in Power BI navigate to File > Options and settings > Data source settings. Find your data source URL from the list, click Edit, edit the credential type to be Anonymous, and click Done. Try again. Please let me know how it goes!

    Serge S Community Team at Wrike ๐ŸŒŽDiscover... Wrike Discover and become a Wrike expert. Click here to get started

    Is this helpful? 1
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Stephen

    @all, just to add to Serge's update above. I also want to let you know we also have a Tableau Connector so you can pull this data to your Tableau database easily. Find out more ๐Ÿ‘‰[New from Wrike]ย BI Export and Tableau Connector (Enterprise)

    ๐Ÿ‘

    Stephen Community Team at Wrike ๐ŸŒŽDiscover... Wrike Discover and become a Wrike expert. Click here to get started

    Is this helpful? 0

Please sign in to leave a comment.

Folllowing List for Post: Anyone using 3rd party or external reporting tools on Wrike data
[this list is visible for admins and agents only]

Community

Welcome ๐Ÿ––

Hi there! ๐Ÿ™‚ Want to become a black belt Wrike Ninja? Here's how to earn a Wrike badge

Welcome ๐Ÿ–– Have you checked out this week's Release Notes yet?

Hey! ๐Ÿ‘‹ Curious about something? Visit How To to search and ask the Community for answers.

Welcome! ๐Ÿ‘‹ Figured out a good tip or trick? Share it in Best Practices.

Want to connect your existing software to Wrike? Learn and ask how in the API section.