PowerBI Desktop免费版：如何切换关联数据库的账户权限？

Hey there, let's get you switched over to your 456@gmail.com account without having to reinstall Power BI Desktop. Here's the step-by-step optimal method that works reliably:

Step 1: Disconnect your current BigQuery connection #

• Open Power BI Desktop, and locate your existing BigQuery data source in the left-hand Data pane.
• Right-click on the data source, select Delete, and confirm the action. Don't stress—this only breaks the connection to the old account, it won't delete your local report files.

Step 2: Clear cached Google account credentials #

This is the critical piece: Power BI stores your login info in Windows' credential cache, so we need to wipe out the old account's data:

• Open Credential Manager on Windows: Press Win + R, type control keymgr.dll, and hit Enter. You can also find it via Control Panel > User Accounts > Credential Manager.
• Switch to the Windows Credentials tab, then hunt for all entries tied to Google, BigQuery, or Power BI (they’ll usually show URLs like https://www.googleapis.com/).
• Right-click each relevant entry, select Remove, and confirm the deletion.

Step 3: Reconnect to BigQuery with your new account #

• Back in Power BI Desktop, click Get Data > More.... Search for Google BigQuery, select it, and click Connect.
• When the login prompt appears, choose Use another account, then enter your 456@gmail.com details and complete the verification flow.
• Follow the standard steps to pick your BigQuery project, dataset, and tables to finalize the connection.

Extra Tips #

• If Power BI still auto-signs into your old account, check your default browser's Google account status—Power BI might pull login info from there. Log out of the old account in your browser first, then retry Step 3.
• If you have multiple report files linked to the old account, repeat these steps for each one to switch them over to 456@gmail.com.

内容的提问来源于stack exchange，提问作者angsty_robot