cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HlaSoe
Regular Visitor

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.

2 REPLIES 2
ashanthakumar
Helper II
Helper II

Hi,

 

       Keep the data file in shared location.

 

Thanks,

Shanthakumar.

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.

HlaSoe_1-1625020171155.png

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

 

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!