Common Issues

Connection issues

"Could not obtain a WAC access token" error

This error occurs when the Excel file is temporarily unavailable or there's a connectivity issue with Microsoft's servers. Solution: Wait a few minutes and try running the data flow again. If the error persists, check that:

• Your Microsoft account still has access to the file

• The file hasn't been moved or deleted

• Your internet connection is stable

If the file is stored in a shared drive, verify that you still have read access to it.

"Cannot connect to OneDrive account" error

This usually means the OAuth connection expired or was revoked. Solution:

1. In your data flow settings, click "Reconnect source"

2. Sign in again with your Microsoft account

3. Grant permission when prompted

4. Run the data flow again

If you recently changed your Microsoft password, you'll need to reconnect as well.

File doesn't appear in the file picker

If you can't find your Excel file when setting up the data flow, it might be:

• Stored in a folder you don't have access to

• Recently moved (refresh the picker and look in the new location)

• Shared with you but not in your main OneDrive folder (check "Shared with me" section if available)

Solution: Navigate through your OneDrive folders in the picker. If it's a shared file, ask the owner to reshare it. For OneDrive for Business files, make sure you're using your work account to sign in.

Missing data

Some rows aren't being imported

Common causes:

• Range is too narrow — If you set a custom range (e.g., A1:D100), only those columns/rows are imported. Check that your range covers all the data you need.

• Sheet name is incorrect — If you manually entered the sheet name and it has a typo, no data will import. Verify the exact sheet name in your Excel file.

• Blank rows in the data — Excel sheets with empty rows in the middle might cause issues. Try removing blank rows or running a filter first.

Solution: Clear any custom range and sheet name filters, then run the data flow again to import all available data.

Headers are missing or duplicated

If you're importing multiple sheets, headers from each sheet get included in the final data. Solution: Use the "Skip header" option when consolidating data from multiple sheets. Enable this if you're using the Append transformation to combine sheets — it will skip the header row on subsequent sheets.

File shows as empty even though it has data

This can happen if:

• The file is password-protected and you don't have the password

• The data is on a different sheet than expected

• The file is very large and still loading

Solution: Open the file in Excel to confirm it has data. Try selecting a different sheet. If the file is password-protected, you'll need to remove the password first.

Permission errors

"You do not have permissions to open this file in the browser" error

Microsoft sometimes restricts access to Office files through web browsers for security reasons. Solution:

1. Check that your Microsoft account has read access to the file

2. Ask the file owner to re-share it with you if needed

3. Try disconnecting and reconnecting your OneDrive account

4. Wait a few hours — the restriction may be temporary

If the file is stored in a shared drive, contact your OneDrive administrator to check permissions.

File is shared with me but I can't select it

Shared files sometimes don't appear in the file picker if the share hasn't fully synced. Solution:

1. Sign into your OneDrive account and confirm you can open the file there

2. Disconnect and reconnect your OneDrive source in Coupler.io

3. Check the file picker again

If it still doesn't appear, ask the owner to reshare it using "Share" → "Anyone with the link" or directly with your email address.

Data discrepancies

Data looks different in the destination than in the source file

This can occur if:

• Formulas in Excel are calculating values that change between runs

• The file is being edited while Coupler.io is importing it

• Date or number formatting is being applied by the destination (Google Sheets, Excel, etc.)

Solution: Check if the raw data is the same in both places. If Excel formulas are the issue, consider exporting their values instead. Avoid editing the source file while a data flow is running.

Numbers or dates are being imported as text

Excel files sometimes store numbers or dates as text, which can cause formatting issues in the destination. Solution: Open your Excel file and verify that columns with numbers/dates are formatted correctly as "Number" or "Date" (not "Text"). Then run the data flow again.

Rate limits

"Microsoft Excel Online is temporarily unavailable" error

Microsoft's Excel service occasionally goes down for maintenance or encounters temporary issues. Solution: Wait 15-30 minutes and try running the data flow again. This is usually resolved quickly on Microsoft's side.

If the error persists for more than an hour, check Microsoft's status page for any ongoing incidents.

Data flow runs very slowly or times out

Large Excel files (10+ MB) or files with thousands of rows can take longer to import. Solution:

1. Try setting a specific range (e.g., A1:Z1000) instead of importing the whole sheet

2. Consider splitting large files into smaller ones

3. If possible, schedule data flow runs during off-peak hours

Very large imports may occasionally hit timeout limits — if that happens, contact Coupler.io support.