Forum Discussion
Power BI Desktop - connect to multiple QuickBook Online accounts
Hi NorthernGuy,
In Power BI Desktop, please open File->Options and settings->Data source settings-> Global permission, find the data source connect to QuickBook Online. Then delete it or Edit the Permission like below:
Best Regards,
Qiuyun Yu
Community SupportHi NorthernGuy,
In your scenario, as you are already signed in to QuickBooks Online in your browser, you may not be prompted for credentials. So you are not able to try different QuickBooks Online account.
If you are running IE browser, please delete stored Autocomplete data such as usernames, passwords, web addresses, and search queries. You can follow steps below:
- Open the Tools menu.
- Select Internet Options.
- Click Content.
- Under AutoComplete, click Settings.
- Click Delete AutoComplete history…
- To prevent AutoComplete in the future, make sure AutoComplete is deselected for User names and passwords on forms, and then click on OK.
- Restart the IE.
Also you can try to run the IE in InPrivate mode by clicking Start InPrivate Browsing to check if you are prompted to enter account when connecting to QuickBooks Online content pack.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Hi Qiuyun,
This didn't work -- I want to confirm that I'm asking about connectivity through PowerBI Desktop.
I access my clients' QBO accounts through both Edge and Chrome -- I went to QBO and ensured that I was logged out and didn't automatically log in when accessing the QBO sign in page. I then cleared all history from the beginning of time on both Edge and Chrome. Then, opened PowerBI Desktop and navigated through Get Data to QBO connectivity -- when I click on QBO it automatically loads the table set from my initial client.
As a next step, after some more digging around on this topic, I have an email addresss from this second client that I am trying to create the PowerBI Dashboard. I went into PowerBI.com and created a new free account using this second email. Then, I went back to PowerBI Desktop and "switched users" and logged into Desktop using my client email address. And again, when Navigating through Get Data to the QBO connection, PowerBI loads my initial client, even though I'm logged in as a different user??
Hope you can help -- in my world, this is important to me!
Thanks.
Hi,
As another step, which I didn't think would work, I went to QBO and logged in under the second company and then went back to PBI Desktop and tried to connect and of course, no change..... still connects to the initial company tables.
Thanks.
- v-qiuyu-msft
Hi NorthernGuy,
In Power BI Desktop, please open File->Options and settings->Data source settings-> Global permission, find the data source connect to QuickBook Online. Then delete it or Edit the Permission like below:
Best Regards,
Qiuyun YuVoila! Thank you.