Server not found - Xero integration

[Geoff123]

Hi, i'm trying to connect Xero to Power BI and it won't work.  In Power BI I select Xero from the Apps and it connects through to Xero fine after logging in.  I select the Xero File (i am an Advisor) and a box comes up saying taking you back to BI, it's then I get this error message from Firefox "Server not found".  I also tried with Chrome and similar error message. 

Has anyone got an idea how to fix this?

Thanks

Geoff

[Geoff123 · Accepted solution]

All fixed thanks a lot! Only issue i see with the integration though is Power BI assumes the financial data is viewed on calander years and hence the graphs that are automatically created are done this way (which is fine for the US) but the Australian financial year in most instances runs from July to June.  Can this be changed as a setting somewhere or do you need to export the info and reload with a date sort?

Thanks

Geoff

[v-yuezhe-msft]

Hi @Geoff123,

The above issue has been solved in last Friday, could you please try again?

Thanks,
Lydia Zhang

[Geoff123 · Accepted solution]

All fixed thanks a lot! Only issue i see with the integration though is Power BI assumes the financial data is viewed on calander years and hence the graphs that are automatically created are done this way (which is fine for the US) but the Australian financial year in most instances runs from July to June.  Can this be changed as a setting somewhere or do you need to export the info and reload with a date sort?

Thanks

Geoff

[karaoan]

Hi @Geoff123

My company (www.managility.com.au) specialises in professional business intelligence solutions for Xero. Our Clear Jelly service enables you to access your Xero data with Power Desktop with full flexibility to change anything in the data model e.g. add your own calculations or combine it with other data sources. If you have further questions feel free to contact me.

Martin

Planning with Power BI? -> www.agilityplanning.com

[v-yuezhe-msft · Accepted solution]

Hi @Geoff123,

Unfortunately, we are not able to edit the data of Xero content pack in Power BI Service. If you want to change date sort, you can consider to export data from the graph to Excel file, then connect to Excel file in Power BI Desktop and re-create your expected chart.

Thanks,
Lydia Zhang

[v-yuezhe-msft]

Hi @Geoff123,

It seems that you get the same issue which is mentioned in this thread. This issue has been reported internally to Power BI team. I will update this thread once I get any feedback.

Thanks,
Lydia Zhang