Forum Discussion
REST api to google big query crashes
we think it was related to having multiple refreshes on the same tables in GBQ at the same time. Since we have organised the refreshes to not run simultaneously it didn't happen anymore
Anonymous
The billing project-id is the Project ID - displayed in the project info card at BigQuery's home page? If yes, I tried it but the error remains. 😞
Hi, all. Thanks Anonymous I managed to sort out this issue. In case someone faces the same problem, here what I've done:
1) Load BigQuery data into PowerBI dataflows, using it as a 'mini' data source.
2) Add the billing-id in the source step (at PowerBi dataflows)
Once it's done, I schedule a refresh between the Dataflows and Google BigQuery, which works just fine. Then I have to change in PowerBI desktop the source of the dataset (from BigQuery to PowerBI Dataflows).
Back to service, I set up the refresh of the dataset to sometime after the refresh of the dataflows is done (I let 2 hours of difference). So far is working fine.
Worth mentioning that Microsoft got in touch with me saying the problem is with BigQuery. But Google BigQuery says the problem is not on their end either - especially because it's possible to update the data through PowerBI Desktop. I hope the solution above help this out.