Domo Office Add-In: Excel rows not updating in Domo

SusieQ

My Domo Excel plugin stopped working, so today I switched to the Domo Office Add-in plugin. When I click update data to update Domo, in Excel it shows 155 rows but in Domo it shows 0 rows. Domo indicates the dataset was refreshed, but it keeps saying 0 rows. Ideas on how to overcome this?

ArborRose

Domo's documentation on the Office Add-ins mentions a need to clear your Microsoft cache if you do not see data.

https://learn.microsoft.com/en-us/office/dev/add-ins/testing/clear-cache

Make sure your authentication token hasn't expired. Try logging out and sign back in to refresh the connection. If the add-in has an option for replace or append, you might try appending to see if there's connectivity.

If you check the schema, does it show column names and data types, but no rows exist? Is this a new dataset or previously used dataset?

SusieQ

@ArborRose Thanks again! I got it to work! Perhaps it was the cache…the data was already in a table. Also I was checking a box that asked to include a Date with the upload; I unchecked it and the rows came through to Domo.

ArborRose

Domo's documentation on the Office Add-ins mentions a need to clear your Microsoft cache if you do not see data.

https://learn.microsoft.com/en-us/office/dev/add-ins/testing/clear-cache

Make sure your authentication token hasn't expired. Try logging out and sign back in to refresh the connection. If the add-in has an option for replace or append, you might try appending to see if there's connectivity.

If you check the schema, does it show column names and data types, but no rows exist? Is this a new dataset or previously used dataset?

SusieQ

Thanks @ArborRose. Thanks for the ideas!! I'll try clearing the cache and doing a restart. It's an existing dataset in Domo, and it shows the column headers correctly but has 0 rows. When uploading, I choose the existing dataset and then replace. It says it completed the upload but the rows aren't coming through.

ArborRose

I don't have experience with the Office Add-in. I understand it needs defined Excel tables, not just raw data ranges. If Domo has headers and says it completed the upload, but there's no rows….that sounds like the data needs to be formatted as a table.

In Excel:

Select the entire dataset including headers. Go to the insert tab and click Table. Click the checkbox that says my table has headers. This creates a table object.

In Domo Add-in:

Select your dataset. Click replace data. Choose the new Excel table, then upload.

SusieQ

@ArborRose Thanks again! I got it to work! Perhaps it was the cache…the data was already in a table. Also I was checking a box that asked to include a Date with the upload; I unchecked it and the rows came through to Domo.

ArborRose

Hizzah! Good to hear you got it working.