cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Power BI + BigQuery = GARBAGE. Refreshes Do Not Work.

I've been using PBI online service with BigQuery for a very long time. Since about Q4 2019, it's becoming super unreliable.

 

I used to link directly to views in BigQuery, than the datasets started to fail to refresh more than to succeed. 

 

We were told to use DataFlows is middleman to get BQ data and then to link PBI to Dataflows. Not even this is working. DataFlows are failing 50% of the time.

 

If you are planning to build complex models on the top of BQ data, don't do it in Power BI. You'll go crazy.

 

This is my DataFlow refresh history:

Refreshes DF.PNG

 

 

3 REPLIES 3
Highlighted
Super User IV
Super User IV

Re: Power BI + BigQuery = GARBAGE. Refreshes Do Not Work.

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Community Support
Community Support

Re: Power BI + BigQuery = GARBAGE. Refreshes Do Not Work.

Hi, @danzrust 

 

The screenshot shows 'schedual refresh' and 'refresh now' both have problems when refreshing. I wonder if there are some error messaages. Do you have this issue for other entities? Please check if you have installed the latest version on-premised gateway and if the gateway is online.

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Helper III
Helper III

Re: Power BI + BigQuery = GARBAGE. Refreshes Do Not Work.

HI Allan,

I don't need any gateway. I'm pulling the data just from BigQuery so I just login in the browser and then the data source is available for dataflow... It's the inconsistency and 50% unreliability which is killing me. 

Today, I tried to manually run the dataflow 4 times. 4 fails. Scheduled ones worked (3x). 

 

This is one of the errors from today: Error: We're sorry an error occurred during evaluation. Request ID: 02355ac1-2c3e-67e3-72eb-070d69d59de7 Activity ID: 20479c7e-53f6-4230-9520-729c2fdb2359 DZ 

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors