Microsoft Forms + Flow + Power BI

[Rebecca7]

Good Morning, everyone!

I created a flow that takes the questions from a form and updates them in a Power BI.

However, I would need to cross this information with two other tables. I've been reading and understood that it is not possible to make relationships between tables and streaming data.

So I thought about doing this crossing of some in Microsoft Flow. Would it be possible to change the response value of the form according to the table (excel spreadsheet) before sending it to Power BI?

Thanks!

[Greg_Deckler]

@Rebecca7 - Not sure I completely understand, can you walk through an example of what you are looking to do?

[Rebecca7]

I'm sorry Greg, I'll try to be clearer!

In my form (Microsoft Forms), I have the entry of two IDs code (one that represents various types of stores and one to identify the user name). Normally, I would put two other tables in Power BI to relate these codes to the names. However, I am using streaming data (with Microsoft Flow) and therefore I cannot do this modeling.

I'd like to know how I could do that. I tried use Microsoft Flow with an Excel trigger but it didn't work.

Thanks for your help