Quickbooks Online - Report function - urlFragment parameter

[timrodman]

When using the Quickbooks Online data source in Power BI Desktop

There is a function called Report

When I try to use the Report function, it asks for a parameter called urlFragment

But I'm not sure what to put in the urlFragment parameter. I tried going to a report in Quickbooks Online and copying the URL into urlFragment, but that didn't work. Any ideas?

[abatahir]

I have connected the QB with BI but the following are missings. 
1. GL table
2. Expense table
3. Reports function

[peterprism]

I am using Quickbooks but when I generating the report it is showing the wrong report and Quickbooks Support function is not working how to solve it.

[gabrieloba]

Hi!

I got an error while trying to connect. That's the message:

Não foi possível importar dados de QuickBooks Online

Erro durante o processamento de dados no conjunto de dados.
Tente novamente mais tarde ou entre em contato com o suporte. Se você entrar em contato com o suporte, forneça esses detalhes.

Tipo de fonte de dados

Erro de processamentoThe column 'Date' of the table wasn't found.

ID de correlação2179f00f-f2db-3f2e-fef6-06713cbf7b98

ID da atividade9f613045-b3ed-40c7-8aca-35467ba55de0

Solicitar IDe73c7c39-bd63-12ab-875c-0b84d1ed7917

Código de status400

HoraWed Sep 06 2017 12:06:28 GMT-0400 (Hora Padrão de Caracas)

Versão13.0.2278.219

Cluster URIhttps://wabi-brazil-south-redirect.analysis.windows.net

[Anonymous]

@timrodman,

I will consult this issue internally and post back once I get updates.

Regards,
Lydia

[timrodman]

Thanks @Anonymous

[Anonymous · Accepted solution]

@timrodman,

Here are some samples of urlFragment parameter values that should work.

/reports/AgedReceivableDetail?date_macro=All

/reports/AgedReceivableDetail?report_date=2015-06-30&start_duedate=2015-01-01&end_duedate=2015-06-30&columns=due_date,cust_name

/reports/CustomerSales?customer=1&start_date=2015-08-01&end_date=2015-09-30

Reference:
https://developer.intuit.com/docs/api/accounting/sales%20by%20customer

Regards,
Lydia

[abatahir]

/\I am not expert to use developer page of QB, is there any way get all list if URLs

[mbuhary]

Lydia,

Could you please provide what url fragments to use to retrieve reports of:

- Profit and Loss; and

- Balance Sheet 

[ZSCPA]

Were you ever able to find an answer to this question? 

[timrodman]

Thank you. That worked!

[Anonymous]

@timrodman,

Glad to hear the issue is solved. Could you please mark my reply as solution to close this thread?

Regards,
Lydia

[tbarron2]

I'm using this function and am having issues with credentials.  When I use Power BI Desktop, it asks for my Quickbooks Online credentials which then results in the scheduled refreshes to fail due to invalid credentials.   If I then validate the QBO credentials by signing in via Power BI Online, then Power BI desktop fails to authenticate when refreshing.   Any ideas on how to alleviate this?