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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors