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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Anonymous,
      Thank You for your Suggestion...

      Regards,
      Hemal