Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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!

Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    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.

     

     

1 Reply

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.