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
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives