What can we help you with?

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

Blog

BI export: Wrike connection problems

9 comments

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

    Hi Marc!

    I've raised a Support Ticket for you, you should receive an email soon and our team will be able to help you with this.

    If you have any other questions let me know! ๐Ÿ˜Š

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

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Yasmeen Wilde

    Hi Hugh, 

    I have the same question as Marc. I got to the name of the table and the storage.www.wrike.com url (see below). How do I get to the columns and data behind the url? 

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Seth Neds

    Yasmeen Wilde I have the the Wrike data connected to Power BI but unfortunately my method doesn't allow for automatic refreshing of the data. Hopefully this can point you in the right direction though.

    I started by getting the location of each of the Wrike CSV documents:

    let
    Source = Json.Document(Web.Contents("https://www.wrike.com/api/v4/data_export", [Headers=[Authorization="bearer token"]])),
    data = Source[data],
    data1 = data{0},
    resources = data1[resources],
    #"Converted to Table" = Table.FromList(resources, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"name", "url"}, {"Column1.name", "Column1.url"}),
    #"Renamed Columns" = Table.RenameColumns(#"Expanded Column1",{{"Column1.url", "url"}}),
    #"Added Custom" = Table.AddColumn(#"Renamed Columns", "Table from Link", each Csv.Document(Web.Contents([url], [Headers=[Authorization="bearer token"]]),[Delimiter=",", Columns=8, Encoding=1252, QuoteStyle=QuoteStyle.Csv]))
    in
    #"Added Custom"

    Then I created a new query for each CSV link (Table from link):

    let
    Source = #"Wrike Data",
    #"Table from Link" = Source{1}[Table from Link],
    #"Promoted Headers" = Table.PromoteHeaders(#"Table from Link", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"audit_log_id", Int64.Type}, {"operator_user_id", Int64.Type}, {"audit_log_object_type", type text}, {"audit_log_object_id", Int64.Type}, {"audit_log_object_title", type text}, {"audit_log_operation_type", type text}, {"audit_log_operation_time", type datetime}, {"audit_log_operation_origin_location_country", type text}})
    in
    #"Changed Type"

    Is this helpful? 4
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Yasmeen Wilde

    Seth Neds it works, thank you so much for sharing your code. 

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Seth Neds

    Yasmeen Wilde You're welcome! I'll glad you got it figured out.

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Daniel Rankin

    Seth Neds Thanks for the M query/Power query tip here, the second level of authorization by URL I'm still wrapping my mind around.  Elegant solution that should go into the Wrike documentation.

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Jacob Wright

    Seth Neds I was able to get all of the queries to pull data from the links. Thank you!

     

    Question- How do I get these queries to refresh? The queries aren't refreshing every hour/day. 

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Seth Neds

    Jacob Wright I apologize for this delayed response.

     

    Question- How do I get these queries to refresh? The queries aren't refreshing every hour/day. 

    From my original post:

    "I have the the Wrike data connected to Power BI but unfortunately my method doesn't allow for automatic refreshing of the data."

    Unfortunately this hasn't changed as far as I know.

     

    If you are able to get the automatic refresh working, keep the following information from Wrike's documentation in mind: "BI Export data is automatically updated once a day. You can use API to check if new data is ready for export."

    https://help.wrike.com/hc/en-us/articles/360019094414-BI-Export

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Seth Neds

    (Edited )

    Jacob Wright  Let me also share with you what my solution was to this issue.

    I setup the Wrike Backup Tool to download the BI Export daily. I then created an SSIS job that runs shortly thereafter and moves all the .csv files into an SQL Server database. I then create my Power BI reports using that data source and am able to successfully refresh every day on our report server.

    I realize that this is not the most elegant solution but it works for us since we don't have a need for real-time data.

    Hopefully this will help.

    Is this helpful? 0
    Comment actions Permalink

Please sign in to leave a comment.

Folllowing List for Post: BI export: Wrike connection problems
[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.