What is my OData URL for to connect power BI desktop to a data set in Power bi service

[deekay1980]

Hi All,

I have a connection with Xero and I would like to try and use the data to model Cashflow forecasting but I can't do that without modeling the date. Now because Xero doesnt have a connection to Power BI desktop I need to get the dataset into desktop somehow. I thought I could you the OData feature but I have no idea to work out what my OData URL is for power Bi service.

Can anyone help?

Thanks
Dana

[GilbertQ]

hi @deekay1980

Could you not potentially connect to your dataset in the Power BI Service using Power BI Desktop using the Get Data Experience.

Here is a link on how to get it implemented.

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-report-lifecycle-datasets/

[deekay1980]

Hi @GilbertQ,

Thanks. Yes I have tried that. Unfortunately, it only connects the reports. It doesnt give me to the the dataset. Would you know why it wouldn't?

If that doesnt work, how do I find the OData URL?

Thanks for your help.

Thanks

Dana

[GilbertQ]

Hi @deekay1980

When you connect via the Dataset in the Service it should just connect to the dataset and then you can create reports?

Do you have a screenshot of what happens when you connect to the dataset?

[deekay1980]

As you can see @GilbertQ I only have the report option on the left hand side and now dataset below or relationship structure.

I am unable to create any new columns or tables or change formatting. It is very annoying.

That is why I thought it might be better to try and connect to Xero via OData???

Thoughts?

[GilbertQ]

Hi @deekay1980

Ok I now understand I would then suggest looking at gettting the data via the OData feed.

[deekay1980]

Thanks. But how do I work out the odata url?

[deekay1980]

[GilbertQ]

Hi @deekay1980

Thanks for the screenshot, is that not what you expected as you now have access to the dataset?