Live Data Connector not finding sheet
Hello,
I've setup the Live Data Connector and it seems to be working correctly. But the sheet I'm an Admin on is not displaying as a possible connection. Does anyone know how I can fix this?
Answers
-
Hi Faith,
This sounds like an issue that would be best addressed with Smartsheet Support so they can troubleshoot this with you. I would suggest providing the following information when you fill out the form:
- Do you have the latest version of the Live Data Connector installed? (You can find download links here: http://smartsheet-platform.github.io/odbc-docs/#download)
- What is the sheet name (and provide a full screen capture, if possible)
- How are you attempting to establish the connection?
They may ask for additional information as well. Here's the link to contact Support: https://help.smartsheet.com/contact/smartsheetapp
Thanks!
Genevieve
-
I know this is an old post, but I've just encountered the something similar when using the PowerBI navigator, which will return a limit of 10,000 records. I've managed to work around this by setting up a second DSN connection for the Live Data Connector using an alias Google account that has a Smartsheet licence assigned to it. This one I use for demos mostly and it's shared to far fewer sheets than my main account, so doesn't hit the limit. This way I've been able to access the sheet I want and connect it to PowerBI.
Hopefully this helps someone.
Phil Robbins
