Help request: streaming data from database to Power Bi

[BaliBiker]

At the moment I use a script given in this threat viewtopic.php?f=72&t=30725&p=259542&hil ... el#p259542 to export data from the Domoticz database to a csv file. This file is copied daily to Gmail using rclone en crontab.

But I think this can be more sophisticated en automated by making use of streaming data to Power Bi by combining the script exporting data to a csv file and the phyton script given in the Walkthrough at this site https://powerbi.microsoft.com/en-us/blo ... -tutorial/

Unfortunately I'm in too much lack of knowledge to do this. Is there anyone out there who has allready done this succesfully or willing to write a script for this?

Thanks in advanced

[maceddy]

There is a french topic about this, have not checked if it works.

I was looking for this as well.. Just for fun..

https://easydomoticz.com/forum/viewtopic.php?t=9308

[waltervl]

Perhaps also check influxdb if you want to store your Domoticz data outside Domoticz for further processing. See wiki:
https://www.domoticz.com/wiki/Influxdb

[waltervl]

And if you want to send something to power BI you can perhaps use the http data push option, see wiki https://www.domoticz.com/wiki/HttpLink