Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Project Parent Hierarchy not shown in PowerBI
Hi there,
I am trying to connect Smartsheet and PowerBI, so that I can visualize data in PowerBI from Smartsheet. I have the connector working, and can pull data from Smartsheet, but it pulls the basic data (row level) for all rows with no way of distinguishing a child row to a parent row. So where I have roll-up summaries, they are being treated as the same kind of data as child data.
The consequence is that when I have a rollup of a budget column, I am getting wacky numbers visualised in Power BI. Is there any way for PowerBI to be passed details of Parent-child row data?
Thanks,
James
Comments
-
Hi James,
If you don't find the answer you're looking for in the Community, I'd recommend reaching out to Microsoft Power BI Support, as Microsoft built the integration.
Cheers!
-
Hi James,
I'm having the same issue. Were you able to contact Microsoft and obtain a solution?
As a workaround, I've added a column for the project name. Although maintaining the data n my project isn't cumbersome, it is an extra element ideally to be eliminated due to potential for human error
