Combining real-time-data with local data in PowerBI Desktop

[Anonymous]

Hello everyone,

I am completely new to PowerBI Desktop and would like to build a dashboard from real-time data (Forms-questionnaire).

Via PowerAutomate, the data is already passed to PowerBI Desktop. My question now would be, if it is somehow possible to insert other Excel data (non real-time) into the data model besides the real-time data, in order to perform calculations with the real-time data. To me, it seems like that doesn't work at all. Can someone here help me if this is even possible?

That would help me a lot!

[v-chenwuz-msft · Accepted solution]

Hi @Anonymous ,

Maybe you can use REST API to upload your data in excel to your real-time dataset on power bi serivce.

Real-time streaming in Power BI - Power BI | Microsoft Docs

Here is an example upload data via python, you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.