@Khalifa Mahgoub I am assuming the billion + row tables are fact tables. Just wondering if you are able to aggregate the tables to a higher granularity (although you may loss some of level of analysis if you aggregate too much but if that it's not an issue, maybe its an option you can consider)

@Michael Flesch this might help Fabric Capacity Events in Real-Time Hub (Preview) | Microsoft Fabric Blog | Microsoft Fabric