Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 
EquipamentoEmailident EquipamentoIdentificadorStatus
E&I - B4[email protected]2 E&I - B11Aprovado
E&I - B3[email protected]-1 E&I - B1-1Aprovado
E&I - B1[email protected]1 E&I - B1-2Aprovado
E&I - B1[email protected]-8 E&I - B1-4Reprovado
E&I - B1[email protected]-7 E&I - B1-5Reprovado
E&I - B1[email protected]-6 E&I - B1-6Aprovado
E&I - B1[email protected]-5 E&I - B1-7Aprovado
E&I - B1[email protected]-4 E&I - B1-8Aprovado
E&I - B4[email protected]6 E&I - B2-1Aprovado
E&I - B2[email protected]-6 E&I - B2-3Aprovado
E&I - B2[email protected]-5 E&I - B2-4Aprovado
E&I - B2[email protected]-4 E&I - B2-5Aprovado


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

  • "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?

    • Anonymous's avatar
      Anonymous
      Not 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".

  • 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.

    • Anonymous's avatar
      Anonymous
      Not 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.