Forum Discussion

HlaSoe's avatar
HlaSoe
Frequent Visitor
5 years ago

Refreshing some datasets works from Desktop version, but not on the online service

I have error message as following when I refreshed some datasets (not all) from Power bi service.

Underlying error code: -2147467259
Underlying error message: The key didn't match any rows in the table.
D7wXshLYyvetxV7vyRrKDpwz44YnUkyRdWJsFMLz: -2147467259
Microsoft.Data.Mashup.ValueError.Key: [Schema = "", Item = "GTSTockCashFlowD"]
Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
Microsoft.Data.Mashup.ValueError.Table: #table({"Name", "Data", "Schema", "Item", "Kind"}, {})
Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: ce19a72b-47c7-4a83-9fe0-36b083538351
Request ID: 73630e97-418c-572c-6dcd-ddc0beadf407
Time: 2021-06-29 01:57:04Z

My original data source is MS Access file stored in my hard drive.

Any advice might be most appreciated.

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

     

           Keep the data file in shared location.

     

    Thanks,

    Shanthakumar.

    • HlaSoe's avatar
      HlaSoe
      Frequent Visitor
      5 years ago

      Thanks for your advice. I had tried to follow but the problem persisted. Keeping datasource in the same location, one dataset could not be refreshed.

      I have been got stuck for almost 2 weeks and could not go further.