Hi Team,
Following is the scenario I am trying to achieve:
1) We have created a Form submission process through Microsoft Form. This is hosted on sharepoint.
2) These form responses are available as individual entries.
3) We need to transform this into an Excel file
4) Use this excel file as a database for PowerBI
5) One of the column in this excel file, is a parameter which will be embedded into PowerBI Web APIs
6) This Web API with parameter value embedded with featch an xml response which we will parse within PowerBI as a table and perform some cleaning to make it presentation ready.
I would like to understand, if there is any PowerBI dashboard sample available which meets the above mentioned architecure & solution. To be specific, steps 4, 5 & 6.
Ideally, if PowerBi would have allowed free form text box to provide input and then handle API interconnection within DAX, I would have taken that solution. However, knowing the current limitation, we can't take that path. Hence, we are using, MSFT Forms, Sharepoint, Excel & PBI. Ideally I would like to do all this within single PBI platform itself.
Let me know, if I need to eve alter the architecture.
Any direction here is helpful and much appreciated.
