Power BI consultants handle data integration by using Power Query to clean and transform data before loading it into Power BI. They create data models and set up relationships between tables for smooth analysis. Real-time updates are managed through scheduled refreshes or live connections. They also tackle integration challenges with optimized connectors and ensure system compatibility. In case of a data center outage, services like HostNoc can help maintain data flow.