Flexy and Microsoft Power BI

Power BI (https://powerbi.microsoft.com/en-us/) is a business analytics service provided by Microsoft.


Here is the procedure to follow for pushing Live Tag data to Power BI :

- Create and configure the  datastream :
  step1.png (Size: 62,12 KB / Downloads: 462)
  step2.png (Size: 15,39 KB / Downloads: 376)
  createdatastream.png (Size: 18,59 KB / Downloads: 410)
- When the datastream is created, copy the URL
  datastreamurl.png (Size: 9,56 KB / Downloads: 378)
- Adapt the following BASIC script with your URL and your Tags (in the Json) :

Code:

PushInterval% = 5
ONTIMER 1, "GOTO PusDataToPowerBI"

PusDataToPowerBI:
TSET 1,0
Url$ = "https://api.powerbi.com/beta/5c7c1590-4488-4e42-bc9c-1f18f8ac994/datasets/4d71a553-1e92-4ba3-acdb-88ae5bf7d40b/rows?redirectedFromSignup=1"
Url$ = Url$ + "&noSignUpCheck=1&response=AlreadyAssignedLicense&redirectedWaitSimple=1&key=V2%2BGZCVK%2FQe%2F%2F64n6yKnEIoeipv31uBrQt8vtEvroWrV2Ha3qGEqeos4gmQen7PuplqojB%2F4J5S4gG0lzSceqQ%3D%3D"
method$ = "POST"
header$ = "Content-Type=application/json"
Json$ = '[{'
Json$ = Json$ + '"Temperature" :' + STR$ Temperature@ +","
Json$ = Json$ + '"Humidity" :' + STR$ Humidity@ +","
Json$ = Json$ + '"Timestamp" :"' + @GetTime$(2) +'"'
Json$ = Json$ +'}]'
PRINT Json$
@HttpRequest$(url$, method$, header$, Json$)
Print "Data Pushed"
TSET 1,PushInterval%
END

Function GetTime$($UTCDiff%)
$a$ = Time$
$GetTime$ = $a$(7 To 10) + "-" + $a$(4 To 5) + "-" + $a$(1 To 2) + "T" + STR$(VAL($a$(12 To 13)) - $UTCDiff%)+":"+$a$(15 To 16)+":"+$a$(18 To 19)+ ".000Z"
EndFn

FUNCTION HttpRequest$($URL_$, $Method_$, $Header_$, $data_$)
REQUESTHTTPX $URL_$, $Method_$, $Header_$, $data_$
$a% = GETSYS Prg,"ACTIONID"
$CHECKSCHEDULEACTION:
SETSYS Prg, "ACTIONID", $a%
$c% = GETSYS Prg,"ACTIONSTAT"
IF $c% = -1 THEN GOTO $CHECKSCHEDULEACTION
IF $c% = 0 THEN
  PRINT TIME$ + " REQUEST OK on ActionID " + STR$ $a%
  $StatusCode% = VAL RESPONSEHTTPX "STATUSCODE"
  PRINT $StatusCode%
  IF $StatusCode% = 200 THEN $HttpRequest$ = "OK" ELSE $HttpRequest$ = "NOK"  
  $Response$ =  RESPONSEHTTPX "RESPONSE-BODY"
ELSE
  PRINT TIME$ + " REQUEST FAILED on ActionID " + STR$ a%
  $HttpRequest$ = "NOK"  
ENDIF

ENDFN

This script pushes the values of the Tags "Temperature" and "Humidity" every 5 seconds (See TSET command) :
  tags.png (Size: 5,85 KB / Downloads: 340) .
- Run the script
- Create a dashboard or a report

  dashboard.png (Size: 20,36 KB / Downloads: 339)
  PowerBIreport.png (Size: 34,22 KB / Downloads: 320)

Simon

Nice and good information. It is very useful for beginners to learn and understand easily.
Learn more about Power BI here: https://goo.gl/fYDNDF

Hello Simon,

Thanks for the script.
Yesterday it worked fine but today al i get is "Operation failed (28) 70 : REQUESTHTTPX url$, method$, header$, Json$"

It's a buffer problem i think because the frist 20 seconds it's pushing data but in PowerBI nothing is showing. (see Attachment)
Do you experinence the same problem or is it something in the Basic scrpit at my end.

Best regards
Gerard

This is strange indeed...
Do you see something in the scheduled actions ? and in the event logs ?

See attachment.

Greets Gerard

Hi,

From what I see in your Scheduled Actions log, you are pushing the data too often (every two seconds) and the Power BI server needs more time to process the data it seems... (You get these Pla- Queue Full errors because there are too many pending HTTP Push actions (max 20) so no other actions can be taken in account)

Simon

Thanks Simon.

It seems to work perfect now.
after setting the intervaltime from 2 to 5 seconds the problem was gone.

Greetz,
Gerard

ah great! Thanks for the feedback and enjoy ;-) !

Thank you for sharing this info!

Iam getting this error: label/function not found (27): Goto ewon_init_section

You guys have any idea?

You probably did erase your init section.
The best is that you erase the BASIC script of your eWON (Reset Level 1 or System > Setup > Storage > Erase & Format > Erase Program) and you copy/paste this script into your Init section.
Do not forget to adapt the script with your own settings.

Thank you. It works now :-)

Hi Simon ,

Can we do the same thing with Ewon CD4xxx instead of flexy 205 ?

Hi Simon ,

Can we do the same thing with Ewon CD4xxx  instead of flexy 205 ?

any answer ?

Unfortunately no, the function "REQUESTHTTPX" is not supported by the CD but only by Flexy (All models).

Simon

Simon,

Have you played with pushing historical tag data to Power BI? It seems like it could be done with EBD but you would need to parse the result of EBD into appropriately formatted JSON using a script?

Mike