Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Excel Output from Microsoft Forms cannot be merged, joined with other data.It's an streaming dataset

I am using Microsoft Forms for a survery. The output file is in an streaming Excel dataset. This part doesn't depend on me...


As you cannot do “joins”, “merge”… dealing with streamed data in power bi reports (in fact "Get Data" you can only get just one source!), I need to convert this Excel output file from Microsoft Forms into a not streamed dataset, so I could use it in a Power Bi report just along other sources….
Is there any way to copy or convert this streamed excel datased to a Power Bi workbook so I could merge it with another files in a Power Bi report? Any “flow?

I suppose it would be what it is called an hybrid file
Many thanks in advance

Javier

Need Help

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Anonymous,

     

    You may use data connection SharePoint folder to get data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thank you very much!

       

      As I read here https://docs.microsoft.com/en-us/power-bi/service-desktop-files "Where your file is saved makes a difference".  I see that a form can be created from Excel Online, Teams, SharePoint, Office 365...

       

      The form was created by a colleague from https://forms.office.com/   ... I will try to use FLow to forward any reponse to SharePoint and then to use Power BI to get the data from Power BI.  I expect that it would be feasible...

       

      I would like some other comment for there is a different alternative.

      Thank you again!
      Javier