Hi All, Do you know when Microsoft will release a way to mirror a database from an On-Premises SQL Server database to a Fabric Data Lakehouse? What is the best way (no code way) to load data from an on-premises SQL Server database into a Fabric data lakehouse? Thanks,

https://learn.microsoft.com/en-us/credentials/certifications/exams/dp-700/

Hi Will. Please do a practical lesson, end-to-end, about how to implement a SCD2 in dimension tables. Do you use SQL procedures or notebooks for that? Is there any low/no code alternative in Fabric, just like MS SSIS has (image in the attachment). Or maybe there is an external service low/no code, that may work on Fabric, for that propose. Thanks

Currently, my company uses MS SQL Report Server for Datawarehousing, on-premises, and . PowerBi Desktop RS for reporting. The pbix reports are consumed via PowerBi Report Serve, on-premises. So, we intend to migrate to Fabric and get the advantage of using notebook for harder data wrangling. My question is how to keep the reports available for internal consumers. Do they have to have a Powerbi Pro/PPU license or not? Is there anything similar to the Powerbi Report Server where consumers can read reports with no need for additional licenses nether extra costs? If not, can I create a report with PowerBi Desktop RS, importing semantic models from fabric, and then put the pbix in the PowerBI Report Server (on-premises) as we are doing today? Thanks

Imagine that all my reports are refreshed only once per day, and all the ETL needs just one hour per day. Although the reports are refreshed only once per day, I need them available 24 hours a day for consumers. So I guess I only need about 31 computer hours per month. Right? Thanks