MERN Stack and Power BI Integration - Help Needed!

Hi, saqibsultan 

To schedule regular data exports to Power BI, consider using a combination of Node.js scheduled tasks for automation and using the Power BI API for data ingestion. You can format your data as JSON, which is very versatile for Power BI ingestion. You can check out the relevant links below:

Push Datasets - Datasets PostDataset - REST API (Power BI Power BI REST APIs) | Microsoft Learn

For live or near-live data pipelines, explore with the live streaming capabilities of Power BI. That way, you can stream your data to Power BI and have dashboards that update in real time. At the same time, you need to pay attention to information security when exporting. You can check out the information below

Use customer-managed keys in Power BI - Power BI | Microsoft Learn

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

To secure the flow of data between your MERN app and Power BI, leverage Azure Active Directory for authentication and authorization. Implement an OAuth2.0 flow to get an access token for the Power BI API.

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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