Live Data Connector not working with Excel Data Model
I'm using the Live Data Connector to pull Smartsheet Data into an Excel Data Model. I then create a simple relationship in the data model. However when I pull the data into a Pivot Table Report, the relationship is not recognized/not honored.
I've created this same simple report using data copied and pasted into the Excel workbook and added to the Data Model, and it works great. But when I use the Live Data Connector, it's as if the relationship doesn't exist. Has anyone else experienced this and found a resolution?
Answers
-
Hello @KJD
I see that you have submitted a case ticket with Smartsheet Support regarding this topic. At this time, this is the better route to take for your specific question!
Kind Regards~
Krissia
-
Thank you Krissia! The answer was that currently the data from the connector does not support relating two tables in an Excel data model with a relationship. I was a bit surprised by this, because once the data was placed in the data model (successfully), the relationship should have been easy. But it did not work and I tried it several ways. Best regards.
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives