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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
timrodman
Helper I
Helper I

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?

1 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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

12 REPLIES 12
abatahir
Helper I
Helper I

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

peterprism
New Member

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
New Member

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

 

v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@timrodman,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Lydia,

 

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

- Profit and Loss; and

- Balance Sheet 

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

Thank you. That worked!

@timrodman,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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? 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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