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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
thimmaraju
New Member

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

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

2 ACCEPTED SOLUTIONS

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.

View solution in original post

Thank you lot for your support. @v-binbinyu-msft @DavidPROVOST , I will convey the same to our client.

View solution in original post

6 REPLIES 6
thimmaraju
New Member

hello @DavidPROVOST , @v-binbinyu-msft ,

 

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?

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.

Thank you lot for your support. @v-binbinyu-msft @DavidPROVOST , I will convey the same to our client.

DavidPROVOST
Advocate II
Advocate II

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
New Member

Hello @v-binbinyu-msft ,

 

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?

v-binbinyu-msft
Community Support
Community Support

Hi @thimmaraju ,

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

vbinbinyumsft_0-1709187814814.png

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors