Skip to main content

Posts

Showing posts with the label Build Backend to move PowerBI datasets to SQL database

Build Backend to move PowerBI datasets to SQL database

Build Backend to move PowerBI datasets to SQL database Client is looking for an experienced backend developer and data engineer to help us build a scalable system that integrates PowerBI REST APIs with SQL databases. This project involves creating a user-friendly, no-code interface that allows users to select archived and live datasets from PowerBI and seamlessly transfer them into an SQL database with additional tags and timestamps. Scope of Work: • Setup and configure PowerBI REST APIs for retrieving datasets across multiple Business Units (BUs). • Create API routes for both archived and current datasets, including tables, measures, and parameters. • Develop a data pipeline to accurately extract, process, and transfer datasets to SQL. • Add meta data (timestamps, meta-attributes) while transferring the data. • Ensure the data model aligns with SQL requirements for efficient storage and retrieval. • Collaborate with FrontEnd engineer to integrate the backend with a no-code interface •...