real time streaming anlytics in power bi by connecting to big query

[thimmaraju]

Hello Team,

Is it possible real time streaming anlytics in power bi by connecting to big query?

Please let me know any articles. I have checked multiple articles but its not connecting it.

Its urgent.

Thanks,

Raju

[Anonymous · Accepted solution]

Hi @thimmaraju ,

Sorry, it could not be achieveable, when you get data from Google Analytics in Power BI Desktop, the storage mode is Import, need refresh the data by manually or set the schedule refresh policy in Power BI Service Portal to get the latested data.

But Fabric provide the real-time analytics, you could try to use.

For more details, you could read related document: Overview of Real-Time Analytics - Microsoft Fabric | Microsoft Learn , What is Microsoft Fabric - Microsoft Fabric | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[thimmaraju]

hello @DavidPROVOST , @Anonymous ,

can we do the streaming anlytics in Power BI by connecting to GA4 (google analytics).

whenever the value is inserting in GA4/BQ then it should auto populate in Power BI without clicking refresh button.

If I set up the report page refresh then its taking 5mins when I set up in 3 seconds.

Is it possible real time streaming anlytics in Power BI by connecting to GA4/Big Query sources?

[Anonymous · Accepted solution]

Hi @thimmaraju ,

Sorry, it could not be achieveable, when you get data from Google Analytics in Power BI Desktop, the storage mode is Import, need refresh the data by manually or set the schedule refresh policy in Power BI Service Portal to get the latested data.

But Fabric provide the real-time analytics, you could try to use.

For more details, you could read related document: Overview of Real-Time Analytics - Microsoft Fabric | Microsoft Learn , What is Microsoft Fabric - Microsoft Fabric | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[thimmaraju · Accepted solution]

Thank you lot for your support. @Anonymous @DavidPROVOST , I will convey the same to our client.

[DavidPROVOST]

You're looking for a BQ trigger on insert that would bounce an external call to PBI streaming analytics. I guess that does not exist.

I suggest auto-refresh at a 1 second frequency, and change auto-detect 

[thimmaraju]

Hello @Anonymous ,

Im able to connect to BIG QUERY but im looking for real time streaming data in power bi. 

real time streaming anlytics. I have to build the streaming anlytics reports using big query.

in BIG Query, data will be updating in seconds, the same way it have to refresh in powre bi reports as well. 

whatever the value is inserting/updating in big query, the value should immediately refresh on Power BI Reports. could you please help me. can we connect if you are available?

[Anonymous]

Hi @thimmaraju ,

Power BI have the built-in connector for Google BigQuery.

For more details, you could read related document: Google BigQuery connector - Power Query | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.