Live Data Connector not finding sheet

Faith Glass-Wilson

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?

Genevieve P.

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

Philip Robbins

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

https://www.prodactive.co.uk/

https://www.youtube.com/%40Smartsheetexpert