Forum Discussion
Solved
Refresh error giving blank cells
I am running into an error where when I refresh my data, it returns blank values in cells where I have formulas. My colleague uses the same sheet and has no issues with refreshes, so I know the logic...
May considering below:
- Check Data Types: Ensure that the data types in your Power Query editor match the expected data types in your Excel sheet. Mismatched data types can sometimes cause issues during refresh.
- Recreate the Connection: Try deleting the existing ODBC connection and recreating it. Sometimes, the connection settings might get corrupted, and recreating the connection can resolve the issue.
- Clear Cache: Clear the cache in Power Query to ensure that there are no stale data causing the issue. You can do this by going to Data > Queries & Connections > Query Properties > Clear Cache.
- Check for Hidden Characters: Sometimes, hidden characters or spaces in the data can cause issues. Ensure that there are no hidden characters in your data source.
- Update Drivers: Ensure that you have the latest version of the Smartsheet Live Data Connector and ODBC drivers installed. Outdated drivers can sometimes cause issues.
- Check for Errors in Power Query: Even though you mentioned there are no errors, double-check for any warnings or messages in the Power Query editor that might provide clues.
- Test with a Simple Query: Create a simple query that pulls a small subset of data from Smartsheet to see if the issue persists. This can help identify if the problem is with the specific query or the connection itself.
- Check Excel Settings: Ensure that your Excel settings are the same as your colleague's. Sometimes, differences in settings can cause issues.
- Review Smartsheet Permissions: Double-check that your Smartsheet permissions are the same as your colleague's. Even though you mentioned it's not a permission issue, it's worth verifying.
May considering below:
- Check Data Types: Ensure that the data types in your Power Query editor match the expected data types in your Excel sheet. Mismatched data types can sometimes cause issues during refresh.
- Recreate the Connection: Try deleting the existing ODBC connection and recreating it. Sometimes, the connection settings might get corrupted, and recreating the connection can resolve the issue.
- Clear Cache: Clear the cache in Power Query to ensure that there are no stale data causing the issue. You can do this by going to Data > Queries & Connections > Query Properties > Clear Cache.
- Check for Hidden Characters: Sometimes, hidden characters or spaces in the data can cause issues. Ensure that there are no hidden characters in your data source.
- Update Drivers: Ensure that you have the latest version of the Smartsheet Live Data Connector and ODBC drivers installed. Outdated drivers can sometimes cause issues.
- Check for Errors in Power Query: Even though you mentioned there are no errors, double-check for any warnings or messages in the Power Query editor that might provide clues.
- Test with a Simple Query: Create a simple query that pulls a small subset of data from Smartsheet to see if the issue persists. This can help identify if the problem is with the specific query or the connection itself.
- Check Excel Settings: Ensure that your Excel settings are the same as your colleague's. Sometimes, differences in settings can cause issues.
- Review Smartsheet Permissions: Double-check that your Smartsheet permissions are the same as your colleague's. Even though you mentioned it's not a permission issue, it's worth verifying.
It seemed to be the data types the smartsheet was pulling in. Adjusting the type in power query editor allowed the formulas to calculate properly. Still weird it was not showing up blank for my colleague, but I am glad I got it fixed. Thank you for the detailed response.