Can't use excel file data as a real time streaming

[hemal_kanjia]

Hello,

I am creating a web service and using the excel file as a source data.
Now I want to do my excel file data as a real time streaming data.
so, Is it possible ?
ultimately, I want to push my excel file data to Power BI, and when I change or update the data in excel file, it should reflect the tile in Power BI automatically without press the refresh button. Is it possible ?
I want to do this by using Web Service.
Can anyone give me the solution or example ?

Thank You.

[v-yuezhe-msft]

Hi @hemal_kanjia,

You can consider to push data from Excel to Power BI using stream datasets. With the Real-time streaming feature, you can create dashboard to display and update real-time data and visuals. For more details, please review the following articles.

Pushing Data From Excel To Power BI Using Streaming Datasets
Real-time streaming in Power BI (Preview)

Thanks,
Lydia Zhang

[hemal_kanjia]

Thanks @v-yuezhe-msft

As per the articles shared by you, this is done through Power Query. That is okey. But the client is not know about Power Query  and that is okey for one excel file. But If there are more than one excel file, at that time, we should write query in all the file. The client wants that he is just update the data in excel and save that. By saving that data in excel, it will directly reflect to Power BI.

Regards, 
Hemal

[v-yuezhe-msft]

---

@hemal_kanjia wrote:

The client wants that he is just update the data in excel and save that. By saving that data in excel, it will directly reflect to Power BI.

Regards, 
Hemal

---

Hi @hemal_kanjia,

There is no direct way to acheive the above requirement in Power BI. If you concern about the complexity of the steaming dataset, you can submit an idea that enable DirectQuery for Excel data source in the Power BI ideas forum .

Thanks,
Lydia Zhang

[hemal_kanjia]

@v-yuezhe-msft,
Thank You for your Suggestion...

Regards,
Hemal

[BhaveshPatel]

Thanks Lydia. This looks Amazing. I will definiteluy give it a shot.

[BhaveshPatel]

Direct Query mode is not supported for the Excel Sources. 

You can use third party product " Power Update" to make it auto refreshable every 1 mintues or so. But it is not in real time.

It is free for the one file. 

Check it out at HERE

[hemal_kanjia]

Thanks Bhavesh...

But I want to do like this:
When I update the data in excel, it will directly reflect to Power BI Tile. It's not like auto refreshable every 1 minutes or so. 
Can we do this using Web Service ? Like we push the data which is in Excel File to the Power BI , So when the data is changed, automatically updated data will be reflected.
Is it possible ? If yes, then kindly give me an example.

Thanks & Regards,
Hemal