Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Connecting Microsoft Forms Pro to Power BI

Hi!    Has anyone connected the Forms Pro preview to Power BI? I've read the documentation, but it offered no concrete steps for making the connection. The Forms pro uses CDS and I'm assuming that ...
Need Help
Tutorial Requests
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous ,

    By my research, I'm afraid that you'd better post your requirement in CDS forum to consult the details step about the connection. There is no direct connector for Microsoft Forms Pro in Power BI currently.

    In addition, you may embed Forms into a web page, get a web url, and use the URL to get data via Web connector in Power BI.

    Best  Regards,

    Cherry

     

glegault's avatar
glegault
Regular Visitor
3 years ago

I found that connecting via the web as the data source, could be a solution.  Simply connect to https://forms.office.com/formapi/DownloadExcelfile.ashx?FormId=

with you FormId pasted in after the =.  It does attempt to connect, my issue is that I can't get any log in's to work.  Organizational account, would make the most sense. But that errors out saying that it's "not supported for this resourse". It maybe due to being in a Hybrid enviroment. It would be nice if Microsoft Account was an option.  I have seen this work before just not in my current enviroment.