Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi @PowerBI ,
I have a dataflow A in DATA workspace, a semantic model A (connected to this dataflow) also in the DATA workspace.
I created a report connecting to the semantic model A and i published it in the ANALYSIS workspace.
I created two new calculated columns in semantic model A.
I found out that if i publish the semantic model A directly to DATA workspace without refreshing. All my views, measures and calculated columns work perfectly. HOWEVER, if i refresh the semantic model A after publishing it (I can refresh it successfully), the calculated columns i newly created do not work anymore, with the error msg 'The query referenced calculated column '_Table'[Column] which does not hold any data because evaluation of one of the rows caused an error.'
Here is one of the calculated column i created:
The issue looks soooooooooooo weird to me. Can anyone help me out? Did anyone have teh same issue before?
Thankssss
use TRY to evaluate the CurrentDate and LastWeekDates separately and see if any errors arise.
IsDateCreatedLastWeek =
VAR CurrentDate = _Table[DATE_OF_CREATION]
VAR LastWeekDates =
CALCULATETABLE(
VALUES(dim_date[Date]),
USERELATIONSHIP(dim_date[Date], _Table[DATE_OF_CREATION]),
dim_date[Offset ISO Week] = -1 || dim_date[Offset Day] = 0
)
VAR LastWeekStartDate = FIRSTDATE(LastWeekDates)
VAR LastWeekEndDate = LASTDATE(LastWeekDates)
RETURN
IF (
NOT (ISBLANK(CurrentDate)) &&
NOT (ISBLANK(LastWeekStartDate)) &&
NOT (ISBLANK(LastWeekEndDate)) &&
CurrentDate >= LastWeekStartDate &&
CurrentDate <= LastWeekEndDate,
1,
0
)
Links to help you :
Hi Amira,
Thanks for your help! it still doesnt work.
i used try and catch, there is no error in the semactic model (when i tried to make a table/bar chart as a test). But it still generates an error 'The query referenced calculated column '_Table'[Column] which does not hold any data because evaluation of one of the rows caused an error.' and / or 'The query referenced column '<oii>LocalDateTable_e1cff804-5c11-409a-b2c2-6ce16587870a6f</oii>'[<oii>Year</oii>] which depends on another column, relationship or measure that is not in a valid state. Additional information: ''.
As long as i dont refresh my semantic model, the calculated columns i created will show/filter everything correctly. Once i refreshed, the same error keeps appearing 😕
So, i just gave up this solution and used another one. It works though not properly ...
Thanks again for your help 😉
User | Count |
---|---|
84 | |
79 | |
71 | |
48 | |
43 |
User | Count |
---|---|
111 | |
54 | |
50 | |
40 | |
40 |