KL1834's avatar
KL1834
New Member
8 years ago
Status:
New

Switch Quickbooks Companies in Desktop

I am using the Quickbooks online connection with PowerBI desktop. I was previously using the connection to get data from one of our subsidaries, but now need to disconnect/log out of that entity and log into our main QBs entity as a different QBs user. I was able to connect to the new/main entity using PowerBI online, but I cannot get BI desktop to switch over. Any tips here??

 

Also, I know it is not a possibility at this time, but it would be great to be able to connect and pull data from multiple QBs Companies into the same datasets. The ability to do live consolidated financial reporting out of quickbooks would be a huge.

Content Packs

6 Comments

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi KL1834,

     

    1. Can you change the data source as the snapshot shows?

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    2. If you can add another query?

    3. I would suggest you create an idea here.

     

    Best Regards,

    Dale

  • KL1834's avatar
    KL1834
    New Member
    8 years ago

    I'm having trouble updating my credentials. It brings me to a blank screen when prompted to log in. I checked on a co-workers computer and his is working just fine. I have uninstalled & reinstalled my PowerBI desktop app. Any other trouble shooting tips?

     

  • JJL1990's avatar
    JJL1990
    Frequent Visitor
    7 years ago

    Hi v-jiascu-msft,

     

    I am having the same trouble where I can update my credentials in Quickbooks except I get a script error before I get into the section to enter my credentials. I didn't have this problem until the start of the year

     

    Kind Regards

    Jai

     

  • BetterIdeaGroup's avatar
    BetterIdeaGroup
    Icon for Helper II rankHelper II
    7 years ago

    I am also no longer able to get into the QuickBooks login page due to the javascript error

     

    Feedback Type:
    Frown (Error)

    Timestamp:
    2019-06-04T00:57:57.9892242Z

    Local Time:
    2019-06-03T18:57:57.9892242-06:00

    Session ID:
    897a4fce-120b-404b-a8be-8b04c48c2f30

    Release:
    May 2019

    Product Version:
    2.69.5467.2151 (19.05) (x64)

    OS Version:
    Microsoft Windows NT 10.0.17134.0 (x64 en-US)

    CLR Version:
    4.7 or later [Release Number = 461808]

    Peak Virtual Memory:
    38 GB

    Private Memory:
    251 MB

    Peak Working Set:
    426 MB

    IE Version:
    11.765.17134.0

    User ID:
    9bfbaed1-77ea-4dfb-8e21-5c444d38f8f0

    Workbook Package Info:
    1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

    Telemetry Enabled:
    True

    Model Default Mode:
    Empty

    Snapshot Trace Logs:
    C:\Users\Ernes\Microsoft\Power BI Desktop Store App\FrownSnapShot717206170.zip

    Performance Trace Logs:
    C:\Users\Ernes\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

    Disabled Preview Features:
    PBI_shapeMapVisualEnabled
    PBI_SpanishLinguisticsEnabled
    PBI_NewWebTableInference
    PBI_showIncrementalRefreshPolicy
    PBI_showManageAggregations
    PBI_improvedFilterExperience
    PBI_qnaLiveConnect
    PBI_keyDrivers

    Disabled DirectQuery Options:
    TreatHanaAsRelationalSource

    Cloud:
    GlobalCloud

    DPI Scale:
    100%

    Supported Services:
    Power BI

    Formulas:


    section Section1;

     

  • AdamBJ's avatar
    AdamBJ
    Regular Visitor
    7 years ago

    JJL1990  BetterIdeaGroup did you install Power BI from the Windows Store or by downloading and installing the MSI from https://powerbi.microsoft.com/en-us/downloads/? If you used the Windows Store option, try reinstalling using the MSI. 

     

    Alternatively (if you don't want to reinstall), you can try setting the FEATURE_BROWSER_EMULATION registry entry for PBIDesktop.exe to a DWORD value of 1100:

     

    https://www.cyotek.com/blog/configuring-the-emulation-mode-of-an-internet-explorer-webbrowser-control

     

    You can follow the instructions to set the entry the start of the article. Make sure create the REG_DWORD at this path: Computer\HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION. The entry at that location should look like this: 

  • BetterIdeaGroup's avatar
    BetterIdeaGroup
    Icon for Helper II rankHelper II
    7 years ago

    Thank you for this followup here and email (yes I am Ernest).  Installing the MSI worked perfectly.  I assume you will let us all know when the app store version will be okay to use. :-) 

     

Completed Ideas