Share via

Internal User cannot Refresh Data from Dataflow

Anonymous
2024-10-24T18:21:02+00:00

We have a MS Team that shares an excel file. I've added data to this file from one of our PBI dataflows, hosted in a workspace. I can refresh the data on my end with no issue. If another user opens the file in Excel Online, we cannot refresh, which is expected (hope this changes with the roadmap for December). However, I expected them to be able to open the file in their local client, refresh the data, and then save whatever changes they need to make. This currently does not work. The following error is given:

[Expression.Error] The key didn't match any rows in the table.

Any help would be appreciated.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-11-18T16:05:26+00:00

    Make sure the Dataflow has been refreshed in the service so that it has data to supply to the spreadsheet first. Make sure the user has permissions to read the Dataflow.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-10-25T01:47:00+00:00

    This is service issue from Microsoft. You may create a support ticket to Microsoft.

    Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. Support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.

    Get support - Microsoft 365 admin | Microsoft Learn

    About how to find the admin in your organization, you can refer to How do I find my Office 365 admin

    Was this answer helpful?

    0 comments