Forum Discussion
Quickbooks Online - Report function - urlFragment parameter
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?
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
12 Replies
timrodman,
I will consult this issue internally and post back once I get updates.
Regards,
Lydia- Thanks Anonymous
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
Hi!
I got an error while trying to connect. That's the message:Não foi possível importar dados de QuickBooks OnlineErro 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 dadosErro de processamentoThe column 'Date' of the table wasn't found.ID de correlação2179f00f-f2db-3f2e-fef6-06713cbf7b98ID da atividade9f613045-b3ed-40c7-8aca-35467ba55de0Solicitar IDe73c7c39-bd63-12ab-875c-0b84d1ed7917Código de status400HoraWed Sep 06 2017 12:06:28 GMT-0400 (Hora Padrão de Caracas)Versão13.0.2278.219I 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.
I have connected the QB with BI but the following are missings.
1. GL table
2. Expense table
3. Reports function
