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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives