topic Re: Real-Time hub > Azure SQL Database CDC in Eventstream

Real-Time hub > Azure SQL Database CDC

Y_AK — Tue, 18 Jun 2024 09:19:29 GMT

As per MS Learn, "Azure SQL DB (CDC)" should be available after turning on the preview feature for the real-time hub.

https://learn.microsoft.com/en-us/fabric/real-time-hub/add-source-azure-sql-database-cdc#add-azure-sql-database-cdc-as-a-source

But only "Cosmo DB (CDC)" can be seen in our environment so far, we have Power BI Premium capacity and South East Asia region, may I know if there's a timeline for when it will be available? Thank you.

Re: Real-Time hub > Azure SQL Database CDC

Anonymous — Wed, 19 Jun 2024 02:47:49 GMT

Hi Y_AK ,

The first thing I need to remind you of is that I see that you mention that you are using Power BI Premium capacity. if you are going to use Real-Time Hub, and the subsequent use of Real-Time Intelligence, eventstream, and other Fabric content that you may need to use all require that you have at least the Fabric Trial capacity.
As well as these data sources you mentioned, they have higher requirements for capacity type licenses, requiring at least Fabric premium workspace:
Add Azure SQL Database CDC as source in Real-Time hub - Microsoft Fabric | Microsoft Learn

Power BI Premium capacity can't use these features of Fabric.

Also, after my testing, there should be 4 data sources over here:

Please contact your organization's global administrator to see if all of these permissions are turned on in the Admin portal > Tenant setting:

There is also the fact that each data source has its own limitations, so please check if you meet these limitations (in addition to the previously mentioned licenses):
Add Azure SQL Database CDC as source in Real-Time hub - Microsoft Fabric | Microsoft Learn
Add PostgreSQL Database CDC as source in Real-Time hub - Microsoft Fabric | Microsoft Learn
Add MySQL Database CDC as source in Real-Time hub - Microsoft Fabric | Microsoft Learn
Add Azure Cosmos DB CDC as source in Real-Time hub - Microsoft Fabric | Microsoft Learn

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

Re: Real-Time hub > Azure SQL Database CDC

Y_AK — Wed, 19 Jun 2024 06:57:25 GMT

Hi Dino,

I have read through all the doc links included in your reply before posting.

As per my understanding, the current Premium per capacity (P SKUs) can enjoy all Fabric experiences (https://learn.microsoft.com/en-us/fabric/enterprise/licenses#capacity-and-skus) until the license ends (https://powerbi.microsoft.com/en-us/blog/important-update-coming-to-power-bi-premium-licensing/)

The permissions have been turning on in the Admin Portal under Tenant settings, that's why we have the preview on the Real-time hub. If permissions are not on, it also cannot explain why "Azure Cosmos DB CDC" can be seen but "Azure SQL Database CDC" cannot be seen in our environment, there's no independent on/off for them.

Since this is the first time I seek for support in this community, may I know if there's another official way to ask for technical support on Fabric?

Re: Real-Time hub > Azure SQL Database CDC

Anonymous — Wed, 19 Jun 2024 07:22:54 GMT

Hi Y_AK ,

I have tested every possible scenario I could think of, but I have not been able to reproduce your situation. If you wish, you can open a support ticket here:
Microsoft Fabric Support and Status | Microsoft Fabric

A dedicated Microsoft engineer will come to solve the problem for you.For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

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

Re: Real-Time hub > Azure SQL Database CDC

Y_AK — Thu, 20 Jun 2024 09:13:19 GMT

Hi Dino,

Thanks for the suggestion.

As of today, "Azure SQL Database CDC" is available in our environment.

Re: Real-Time hub > Azure SQL Database CDC

Anonymous — Fri, 21 Jun 2024 01:21:21 GMT

Hi Y_AK ,

Glad to hear you've solved your problem, and it would be great if you could share with us how you solved it!

Best Regards,
Dino Tao

Re: Real-Time hub > Azure SQL Database CDC

Y_AK — Fri, 21 Jun 2024 01:38:40 GMT

Hi Dino,

It's just suddenly appear, maybe MS Admin read my post here