Forum Discussion
Realtime dataset not working
Hello, how are you doing? I really need your help.
I have a streaming dataset with historic data turned on that is connected to a report using mixed stored mode. Below is a sample of the data in the realtime datatset and static dataset (import mode):
| Static dataset (Dados table) | Realtime dataset | |||||
| Equipamento | ident | Equipamento | Identificador | Status | ||
| E&I - B4 | [email protected] | 2 | E&I - B1 | 1 | Aprovado | |
| E&I - B3 | [email protected] | -1 | E&I - B1 | -1 | Aprovado | |
| E&I - B1 | [email protected] | 1 | E&I - B1 | -2 | Aprovado | |
| E&I - B1 | [email protected] | -8 | E&I - B1 | -4 | Reprovado | |
| E&I - B1 | [email protected] | -7 | E&I - B1 | -5 | Reprovado | |
| E&I - B1 | [email protected] | -6 | E&I - B1 | -6 | Aprovado | |
| E&I - B1 | [email protected] | -5 | E&I - B1 | -7 | Aprovado | |
| E&I - B1 | [email protected] | -4 | E&I - B1 | -8 | Aprovado | |
| E&I - B4 | [email protected] | 6 | E&I - B2 | -1 | Aprovado | |
| E&I - B2 | [email protected] | -6 | E&I - B2 | -3 | Aprovado | |
| E&I - B2 | [email protected] | -5 | E&I - B2 | -4 | Aprovado | |
| E&I - B2 | [email protected] | -4 | E&I - B2 | -5 | Aprovado |
In the report, there is a measure to correlate the data from the realtime dataset to the static dataset and return the "Status" based on the value of the static dataset. The measure is:
test =
var equip = FIRSTNONBLANK(Dados[Equipamento], 1)
var ident = FIRSTNONBLANK(Dados[ident], 1)
return CALCULATE(CONCATENATEX(RealTimeData, RealTimeData[Status]), FILTER(RealTimeData, RealTimeData[Identificador] = ident && RealTimeData[Equipamento] = equip))This was working fine for about a month, until today, when a row that was in the realtime data was not retuning the "Status".
Taking a deeper look in the formula, I was able to find out that if I replaced the variables "equip" and "ident" in the formula for strings of what I wanted to find, it returned the "Status":
test =
CALCULATE(CONCATENATEX(RealTimeData, RealTimeData[Status]), FILTER(RealTimeData, RealTimeData[Identificador] = "1" && RealTimeData[Equipamento] = "E&I - B1"))Doing another test, I discovered that if I defined the variables and still use the string in the filter, it would not work:
test =
var equip = FIRSTNONBLANK(Dados[Equipamento], 1)
var ident = FIRSTNONBLANK(Dados[ident], 1)
return CALCULATE(CONCATENATEX(RealTimeData, RealTimeData[Status]), FILTER(RealTimeData, RealTimeData[Identificador] = "1" && RealTimeData[Equipamento] = "E&I - B1"))Note: this situation only occurs if I am looking for the value "E&I - B1" in the column "equipamento" and the value "1" in the column "Identificador", with all the other values the formula works fine.
I managed the solve this issue by deleting all the data in the realtime dataset and re-uploading again, without any changes in the formulas. However, this is not a viable solution if this happens again, so, I would need your help in a more permanent solution to this issue.
Thanks in advance.
4 Replies
- lbendlinSuper User
"I have a streaming dataset with historic data turned on that is connected to a report using mixed stored mode."
How did you do that? I thought that was impossible.
On a side note - where is your UTC timestamp column?
- AnonymousNot applicable
You can enable it on preview feaures:
I don't really have a timestamp column. The only columns I am comparing are "Equipamento", "Identificador" and returning the value from the column "Status".
- lbendlinSuper User
I still don't know how you did that. Whenever I try to add a local data model to a streaming hybrid dataset that is housed in a premium workspace I only get an error message
I can connect to the dataset fine but it is a live connection, and I cannot switch it to Direct Query.
- AnonymousNot applicable
I managed to do it by creating the live connection dataset on a pro workspace, then adding the live connection and the import queries to a report that I published on a premium capacity workspace.