Help with Wrike Import to Power BI (Task/Folder Mapping)

Hello, I am getting started with connecting Wrike to PowerBI. I have used the Beta Wrike connector.

It has mostly gone smoothly, but I'm having an issue I can't resolve. I am sure the solution is simple but I can't figure it out.

I am trying to manage the relationship between tasks and folders. I have successfully established the relationship between timelog and task, so I can show time spent by task title, for example. I have similarly established the relationship between users (Contact) and timelogs, so I can show time entries by name instead of user ID, for example.

However I am not able to establish the relationship between the task and folder, so I can report on how much time is spent per folder/project.

Can someone point me in the right direction, including documentation if needed? I am new to PowerBI. So far I have made edits with the powerQuery, set up my own custom columns, and made relationship edits, but this one simple connection I cannot figure out. Thank you very much for your guidance here. 

 

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
Комментариев: 5

Hi Amanda Stephens, thank you for creating this post! I've raised a ticket with our Support Team on your behalf and one of our experts will contact you shortly to assist you with this 👍

Juan Community Team at Wrike Wrike Product Manager Узнайте о самых популярных функциях Wrike и советах по его использованию

Juan Wrike Team member Узнайте о самых популярных функциях Wrike и советах по его использованию

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Thanks Juan! I had figured it out in the meantime but the Wrike support team provided this answer which may be helpful to others:

Katsiaryna from Wrike Support is here.
Thank you for reaching out!
 
Please note that the account-wide table "All tasks" doesn't include details on the parent items. Instead, you would need to use the "All Tasks - 'Space name'" table under the Spaces:



Space-level tables contain "parentIds" column that includes IDs of parent items.


0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hello Amanda Stephens,

Do you have the pinnacle or enterprise licence? I am trying use the Beta Wrike connector instead of importing my dimensions tables & perhaps facts tables.

Thank you!

Isabelle

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi Isabelle, we are on Enterprise Pinnacle. Based on the note here the connector is visible for all plan levels but only usable by Enterprise Pinnacle plans.

What plan are you on? 

https://help.wrike.com/hc/en-us/articles/14918588863895-Wrike-Power-BI-Connector

I probably only have 5% knowledge of how to use this but it was better than the 0% I had when I posted the comment so if there's any questions I can help answer I am happy to do so :) 

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Help with Wrike Import to Power BI (Task/Folder Mapping)
[this list is visible for admins and agents only]

Вверх
Didn’t find what you were looking for? Write new post