Forum Discussion
Scheduled Refresh
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
