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

7 Replies

    • BhaveshPatel's avatar
      BhaveshPatel
      Super User
      9 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Thanks Anonymous

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago
        Anonymous 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 Anonymous,

        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

  • 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