Forum Discussion

DrillDownBI's avatar
DrillDownBI
Icon for Helper I rankHelper I
3 years ago

Streaming Dataset from local txt file

Hi, I have a .txt-log file that updates every 1 sec, this is located on a local disc. Is it possible to use a Streaming Dataset (in service) to read from this file? The file has timestamp and 5 me...
Need Help
Migasuke's avatar
Migasuke
Icon for Memorable Member rankMemorable Member
3 years ago

1. Having either Azure Stream, script on Virtual Machine, eventually have some on premises computer, which would run the script (I personally use Raspberry Pi for real.time). Personally if you can, try it first with your local pc. Write some script , script can run locally and when you see the bavior publish it on VM.

DrillDownBI's avatar
DrillDownBI
Icon for Helper I rankHelper I
3 years ago

I'm going to use the API, nothing else could be used for my purpose. But then, how should I get the txt-data into Power BI?

  • Migasuke's avatar
    Migasuke
    Icon for Memorable Member rankMemorable Member
    3 years ago

    This is the most difficult part, where I can't help.
    You need script, ie Python, Power Shell etc. which will read the file, take the new text, wrap it into JSON and send it to PBI Service.
    Ofcourse writing this script can be extremely difficult. I would recommend to check other communities, which are focusing on this topic.