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
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?