Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

How to create real time visual using Excel ?

Hello,

I am using Excel File as an Input Data. Suppose, There are 5000 records in my file. Now I want to do like "one by one, records come from Excel File to Power Bi.( Just like streaming Dataset ) So, Is It Possible ? Please give me the solution of this.

I found from somewhere that this is done through "Web Service", but I don't know how to create. Can anyone give me the example of that if it is possible ?

 

Thank you,
Hemal

Need Help

2 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi Anonymous,

     

    Based on my research, I don't aware how to do it through "Web Service" in this scenario. And I think it may be a good choice to use Streaming Dataset directly as you have mentioned above.:smileyhappy:

     

    Regards

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Thank you v-ljerr-msft,

      But I want to make dashboard which is in your shared link, but using excel file.

       
      Suppose, I have one excel file and it contains one column which has values 100,200,300,400,...... and so on. Now I put one Card in my dashboard. The Value of that card is that column. so, It ( Card ) should displays all the values one by one like first display 100, after that 200 and so on. Is It Possible ?

      Thanks and Regards,

      Hemal