Loading Reports in PowerBI service using BigQuery

Hi @EJohnK,

Please refer to the process in the link below for the takeover of the dataset.

How To Handle Power BI Data Refresh Error - Refresh Token Expired (c-sharpcorner.com)

Inside Power Bi Service and the workspace you have published go to the Dataset Settings and check the section Data Sources Credentials to edit them. Try to select OAuth2 in Authentication Method as depicted below and click on Sign in. If you have not created a data source, you can refer to this document to create one. Add or remove a gateway data source - Power BI | Microsoft Learn

If the popup does not offer service account login, clear the cache or try with other browsers. 

For more detailed information refer to Google BigQuery connector - Power Query | Microsoft Learn

If adding credentials fails you can refer to the following link to resolve the problem. Solved: Not able to Add Credentials to Google BigQuery - Microsoft Power BI Community

Best Regards,

Neeko Tang

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