Little Data, Big Problem (Live Data Connector)

I'm still trying to work with a data set (Smartsheet report) that has 217K rows x 32 columns.

Using the data connector, excel can connect but not import the report data unless I reduce the number of rows. I tried breaking up data into fiscal year reports. I was able to connect to each report but could never append the data in excel to work with as single data set. I tried multiple times using 32 and 64 bit versions of excel, win7 and win10.

Today I tried working with the Power BI desktop app. The odbc connection works fine but I still get a same problem: "The table has no visible columns and cannot be queried".

Next steps:

1) try working with smaller reports in Power BI desktop

2) try QlikView desktop

3) try Tableau desktop

Find more posts tagged with

Comments

Mike L.

Tried Qlik Sense desktop except it can't find the Smartsheet DSN

(swing and a miss !)

Mike L.

Tableau desktop has been loading metadata for over 7 minutes, .......

Mike L.

Tableau says: An error occurred while communicating with Other Databases (ODBC). Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

There was an error executing an SQL query: 'no such table:

ODBC connections do work with small reports but refresh slowly as the report results increase. I'm running into the same issue with excel, Power BI, Tableau. Right now I'm going to guess that this is a smartsheet issue (unable to pass report data after the number of report rows exceeds a certain number).

Sign in to join the conversation!

Quick Links

Trending discussions

User Activity
I've been wondering about this for awhile, is there a place where you can find your user activity for any comments, or questions you've helped answer etc.. I know there is a Activity in your Profile for badges and achievements but im looking for your activity within the community. Ex: I've answered a question, and now its…
Notification Automations - Links in messaging
When creating a notification automation that includes a url directing a receiver to a report, dashboard etc., sometimes the url that I copy and paste into the message us not clickable, and the receiver has to copy and paste. Is there a step that I am missing to make is a clickable link?
drag and drop feature not working
HI Can you tell me if the drag and drop from email to Smartsheet feature will be back available in Windows 11.