Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Y_AK
Regular Visitor

Real-Time hub > Azure SQL Database CDC

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-s...

 

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.

 

Y_AK_0-1718702002863.png

 

1 ACCEPTED SOLUTION

Hi Dino,

 

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

View solution in original post

6 REPLIES 6
Y_AK
Regular Visitor

Hi Dino,

Thanks for the suggestion.

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

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

Hi Dino,

 

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

v-junyant-msft
Community Support
Community Support

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

vjunyantmsft_0-1718764825062.png

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

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

vjunyantmsft_1-1718765040203.png

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

vjunyantmsft_2-1718765148587.png

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.

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?

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

vjunyantmsft_0-1718781699722.png

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.

 

Helpful resources

Announcements
FabricCarousel_June2024

Fabric Monthly Update - June 2024

Check out the June 2024 Fabric update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors