Streaming Dataset from local txt file

[DrillDownBI]

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 measure value. 

[DrillDownBI]

Hi @Migasuke 

1. You need some service, which will push data into dataset. --> OK, some service you said, can you elaborate
2. Real-time dashboards are different from reports. --> Yes I will use Dashboard
3. Data can be pushed max. once per 1 second. --> Will be perfect for my use

[Migasuke]

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]

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]

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.

[Migasuke]

Hi @DrillDownBI ,

Yes you can take advantage of streaming dataset, just bear in mind few things:
1. You need some service, which will push data into dataset.
2. Real-time dashboards are different from reports.
3. Data can be pushed max. once per 1 second.

Check more here:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming