EDIT:
The error is:
Expression.Error: The key didn't match any rows in the table.
Details:
Key=
workspaceId=xxxyxxxy-yxxx-xyxx-yyyyyyyxxxxxxxyy (anonymised, where x = number, y = letter)
Table=[Table]
I still have a problem mentioned here:
Expression.Error: The key didn't match any row... - Microsoft Fabric Community
The problem appears when there have done some changes in data source. The strange thing is that the report still receives data, so it works in part. Probably one of the columns is broken
In my best guess or solution at the moment is that there is dataflow which isn't connected (or connected correctly) to my report.
In the Power BI Service (report's prod workspace) there is a lineage view and when I look at it, there are a couple of data sources. One can be found in desktop, the other not (I mean when doing source --> Data column Folder --> Continue --> There is a list of workspaces / dataflows (columns: workspaceId, workspaceName, workspaceType etc.) that I have access to (or what can be used in report, I'm not sure?) but there are no this other dataflow that I need.
SO: Does anyone know, why there is not this other dataflow, because it should work.
And I have tried data source settings --> global permissions --> clear permissions and new source --> dataflow --> log in --> but it is NOT there either.
Do I need to have dataflow available on my desktop (i.e. permissions, or whatever?) for the report to work correctly and the error to disappear? Anyone have any guesses or knowledge of a solution to the problem?
Could someone please help me that I can solve it before xmas 😄
Thank for your time and thanks in advance!
Greetings,
Gandhi
