Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to Solution.
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
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 Yu
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
24 | |
12 | |
11 | |
11 | |
8 |
User | Count |
---|---|
42 | |
25 | |
14 | |
14 | |
12 |