Forum Discussion
Bigquery Power BI Web Service refresh issuee
Hi alex55
You might refer to this post:
https://community.powerbi.com/t5/Service/REST-api-to-google-big-query-crashes/td-p/800366
Hey Alex,
Like Dina said, the current "solution" is to use a Dataflow as a data source instead of directly using bigquery as a data source. There is a bug in powerBI service or Bigquery that prevents it from working properly without using a dataflow. On the plus side, using dataflow has been 100% reliable for me, it never fails.
It would be a great help to me if you could respond in this Bug report to Google : https://issuetracker.google.com/issues/145895341
Microsoft is currently pointing a finger at BigQuery for having the issue, and I would like to make sure that it's not their issue.
Thanks!
Hey Alex,
Like Dina said, the current "solution" is to use a Dataflow as a data source instead of directly using bigquery as a data source. There is a bug in powerBI service or Bigquery that prevents it from working properly without using a dataflow. On the plus side, using dataflow has been 100% reliable for me, it never fails.
It would be a great help to me if you could respond in this Bug report to Google : https://issuetracker.google.com/issues/145895341
Microsoft is currently pointing a finger at BigQuery for having the issue, and I would like to make sure that it's not their issue.
Thanks!
So I've refreshed my dataset to use BigQuery>DataFlow>Dataset route and guess what. That piece of cr** is failing too. This overall BQ experience with Power BI has been 100% hopeless recently.
The first DataFlow refresh went OK, now I'm getting:
Error: We're sorry an error occurred during evaluation. Request ID: 3ae08f0e-d50f-02eb-2ac5-b8c8fc5f2d12 Activity ID: f75001d0-8a07-4f0c-99bf-e1b46a4102c0
Error: We're sorry an error occurred during evaluation. Request ID: 3f758db2-382e-4df2-bda8-77678c3b9821 Activity ID: ff82df66-3b30-4479-9904-3967939b6c29
These errors are from the dataflow refresh, not from the dataset refresh.
When I preview the tables loaded from BQ in the DataFlow section, I can see them OK, they load pretty fast. I'm only getting this error for one table:
Some complex types cannot be loaded in query XYZ.
And as a final punch, when I was writing this post for the first time, the posting failed too and I lost everything!
Seems like nothing is working here.