Scheduled Refresh

leylarm · ‎10-31-2018

Hello to everybody

I connected SQL Server to Power BI. And i've decided to generate the schedule - to collect the data from sql table once a day.

But it didn't work. I've received the following error :

Last refresh failed: Wed Oct 31 2018 12:01:34 GMT+0400 (Azerbaijan Standard Time)
Cannot connect to the mashup data source. See error details for more information.Hide details

Underlying error code:	-2147467259 Table: Day.
Underlying error message:	The key didn't match any rows in the table.
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.Key:	[Item = "Day", Kind = "Sheet"]
Microsoft.Data.Mashup.ValueError.Reason:	Expression.Error
Cluster URI:	WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID:	424cc421-40d6-4d3c-9e34-2394bff8a475
Request ID:	34b5d98b-e083-4b38-ad3a-f348032f35cb
Time:	2018-10-31 08:01:34Z

Kindly ask to help

v-chuncz-msft · ‎11-01-2018

@leylarm,

Go through each step of the query in The Advanced Editor to troubleshoot this problem.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.