This has been an issue every now and then for the last year. But now since last friday it's dramatic. None of our queries are refreshing, like they were before. Message: Error interacting with R...
Hey Johan, did you try this workaround:
https://community.powerbi.com/t5/Service/REST-api-to-google-big-query-crashes/m-p/872650#M82938
It's basically getting the data into a (simple!) Dataflow, and using that as your data source. Dataflow seems to be very reliable in refreshing my data. (100% success rate for many weeks now).
It's a shame the PowerBI devs don't think this is an issue. They want us to be middle-men to communicate between them and google for some reason, very inefficient.