The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi
I get an email about refresh failure every 2-3 days.
The error is:
Refresh failed: Usage has failed to refresh. Failure details: Column 'Version' in Table 'Common versions' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. Table: Common versions.
It should be easy to understand that the table 'Common versions' contains empty rows under 'Version' column, however, the query is something like this:
union app_start | where PipelineInfo_IngestionTime between (startofday(ago(28d)) .. startofday(now())) | where isnotempty(App_Version) | summarize (t, Version) = arg_max(PipelineInfo_IngestionTime, App_Version) by Machine = Device_Id | top-hitters 10 of Version | project Version = NormalizeVersion(Version), Machines = approximate_count_Version | where isnotempty(Version)
The app_start table has tons of data and the query result is never empty
From time to time I also get the following refresh error:
Refresh failed: Usage has failed to refresh. Failure details: We cannot convert a value of type Record to type List. Table: Common version index.
Any ideas what the issue might be?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.