This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 44%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
I need to bring real time data from Azure SQL database to Microsoft Fabric Lakehouse. I checked for the option of Fabric Mirroring but there are many challenges in it so i need an alternative solution with realtime data availability. Please help me with all possible methods.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
@Jothi Lakshmi P M Just checking in to see if the below answer provided by @Nandan Hegde helped.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
@Jothi Lakshmi P M Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Due to the limitations in Fabric mirroring, such as the current restriction of only 500 tables being mirrored, I need to find an alternative approach. Is it possible to bring data from Azure DB to Fabric Lakehouse using an event stream? Can you help with this? I am looking for solutions to bring data from azure db to event hub and then it can be streamed to lakehouse.
@Jothi Lakshmi P M Following up to see if the below answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
you need to have a job to sync data from Az SQL database into fabric via Azure data factory or other offerings.
And you can use external rest end point to trigger the sync job at real time :
Fabric mirroring is the most real time that it can get but other than that above is the only way I feel is possible
Hi @Jothi Lakshmi P M - Regarding your approach and what you're seeking, it would be more effective to share your query on the Fabric platform for better assistance. Could you kindly retake the survey and post your question on the MS Fabric platform as indicated below.
You can ask the experts in the dedicated MS Fabric community forum.
Can you please open as a new thread in MS Fabric community: https://community.fabric.microsoft.com/t5/Power-BI-forums/ct-p/powerbi
Hope this helps. Do let us know if you have any further queries.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
@Jothi Lakshmi P M Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.