I've posted this on the forums and had no success, so I'm filing my issue here.
I work for an irrigation development company. The visual in question is a matrix with information like dam names, water storage levels, differences, and so on.
On the online report, the visual fails to load with the following error message:
This does not happen in the desktop version of PowerBI and the visual loads fine.
I'm not using the ADDMISSINGITEMS function anywhere in the report, and only one table has a column named 'Dam Type' (which the visual has a lookup for). The table is constructed with the formula
DataDamCW = FILTER(DataDamAll, NOT(ISBLANK([Dam ID])) && RELATED(Calendar[IsCurrentWeek]))
and the table containing 'Dam Type' has a *:1 relation on DamDataAll.
The data sources are a SharePoint list (dam info, the lookup table) and an Excel spreadsheet hosted on SharePoint (for the actual data). The current week data is a filtered version of the Excel data.
Below are the relations between the relevant tables:
- DataDamCW and InfoDam are linked on Dam ID/ID, a unique integer for each dam.
- InfoDam and DataDamAll are linked on Dam ID;
- DamDataAll and CalendarMeasures are connected on the date.
I don't know when this issue started as I was on leave when it first occurred, but it may have been sometime around April or May (definitely after Feburary).
-
v-xiaoyan-msft
on:
Frequent "Cache.Key is denied" Refresh Failure on ...
- mrmossevig on: Fabric Capacity App fails to load with 'An error o...
-
v-yetao1-msft
on:
Something went wrong endless loop
-
v-xiaoyan-msft
on:
Slicer bug?
-
Element115
on:
BUG::SLICER::IDbConnection interface
- spindive on: Possible Bug with Rounding
-
v-xiaoyan-msft
on:
export to excel
-
v-xiaoyan-msft
on:
Is there any way to see the full name of the colum...
- Lingaraj-Mishra on: Issue with Client Credentials Grant Type for Power...
- MattSwan on: Multi-Select Possible in Filter Panel even when Re...