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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors