Forum Discussion

Danetech's avatar
Danetech
Regular Visitor
9 years ago
Solved

Power Bi & MS Forms

Can you get data from a Microsoft Form on 0365, rather than downloading the excel spreadsheet and using that.   Thanks :smileyhappy:
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Danetech,

    You need to  embed Forms into a web page, get a web url, use the URL to get data.

    Best Regards,
    Angelia

fduran's avatar
fduran
Advocate I
7 years ago

Does anyone know if Microsoft has any plans on creating a connector for MS Forms?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I have several forms that were created from within sharepoint, so the associated excel file is visible in our sharepoint site - I cannot get PowerBi to read from these

 

If the same folder, I have a "Master File" which is populated via MS flow whenever an entry is made using any of the forms - This one I can get power BI to read setting up as

Get data>web>(link to the file minus everytihing in the address after the .xlsx)

 

I don't understand the different behaviour. I would like to try and get Power BI to read the excel files from each individual form and combine so I can bypass the MS flow part