Forum Discussion
xero
Hi,
I am having a problem getting data from the correct Xero company - there are 7 to choose from. Having gone through the sequence: Get Data/Services/Xero/Connect to Xero/Next, I then do not get the opportunity to select the appropriate Xero company. Instead it defaults to the first company in the alphabetic list and brings in the wrong dataset.
When I first started using Power BI I did get a choice and got the correct company. I subsequently deleted that dataset and dashboard but when I attempted to replace the same dataset and dashboard I found this problem arose.
Any ideas?
regards
HJi Qiuyun_Yu
Thanks for the response.
I have now found a solution to this. If you put in a nickname you get the results in my initial query. However if you put in the actual Xero company account name you then get the Xero choice screen to select the company you want.
regards
2 Replies
Hi sirgov,
Do you mean when you connect to the XERO content, it's default to the first organisation instead typing prefer organisation, right?
Based on my test, I can specify which organisation can be connected to once click Xero > Get. Also I can select different company when I sign in the XERO. See:
In your scenario, please check how many companies you specified within your XERO account.
Also clear the browser history and cookies then connect to XERO content pack again. Or you can try a different browser to run the Power BI Service to see if you can see the same option like above.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun YuHJi Qiuyun_Yu
Thanks for the response.
I have now found a solution to this. If you put in a nickname you get the results in my initial query. However if you put in the actual Xero company account name you then get the Xero choice screen to select the company you want.
regards
