Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
sirgov
Regular Visitor

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

1 ACCEPTED 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

View solution in original post

2 REPLIES 2
v-qiuyu-msft
Community Support
Community Support

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: 

 

q4.PNGq3.PNG

 

 

In your scenario, please check how many companies you specified within your XERO account.

 

q5.PNG

 

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.