Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

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 ...
BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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