MERN Stack and Power BI Integration - Help Needed!

As a MERN stack developer I'm building an application that tracks user data and activity. I'm looking to leverage Power BI for in-depth data visualization, but I'm facing some integration challenges.

Problem:

I'm seeking the most secure and efficient way to get my MERN application's data into Power BI. Here are my key goals:

1. Automated Data Export:

   • I need to schedule regular exports (daily/hourly) of user and activity data in a format compatible with Power BI (CSV, JSON).
   • Maintaining data security during export is crucial, potentially involving anonymization of sensitive information.

2. Exploring Real-time Data (Optional):

   • I'm interested in investigating options for establishing a real-time or near real-time data pipeline between the MERN application and Power BI for more dynamic dashboards.

Additional Considerations:

• Authentication & Authorization: How can I implement robust authentication and authorization mechanisms to secure the data flow between my MERN app and Power BI?
• Data Transformation: Are there Node.js libraries or tools that can simplify data formatting for seamless Power BI ingestion?

I have a solid foundation in MERN development and basic Power BI functionality. However, I'm reaching out to the community for guidance on best practices for this integration.

Looking for:

• Advice on secure and efficient data export scheduling within the MERN stack.
• Insights on potential real-time data pipelines (if feasible).
• Recommendations for implementing robust authentication and authorization strategies.
• Tips on leveraging Node.js tools for streamlining data transformation before export to Power BI.

Any insights or suggestions from experienced MERN stack developers or those familiar with MERN-Power BI integrations would be invaluable!