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

Find more posts tagged with

Construction

Sheets

API and Developers

Integrations

Project Management

Comments

Shaine Greenwood

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!

swinrow

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