cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Quickbooks Online - Report function - urlFragment parameter

@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

9 REPLIES 9
Highlighted
Microsoft
Microsoft

Re: Quickbooks Online - Report function - urlFragment parameter

@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.
Highlighted
Helper I
Helper I

Re: Quickbooks Online - Report function - urlFragment parameter

Highlighted
Microsoft
Microsoft

Re: Quickbooks Online - Report function - urlFragment parameter

@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

Highlighted
Helper I
Helper I

Re: Quickbooks Online - Report function - urlFragment parameter

Thank you. That worked!

Highlighted
Microsoft
Microsoft

Re: Quickbooks Online - Report function - urlFragment parameter

@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.
Highlighted
New Member

Re: Quickbooks Online - Report function - urlFragment parameter

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

 

Highlighted
New Member

Re: Quickbooks Online - Report function - urlFragment parameter

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.

Highlighted
Regular Visitor

Re: Quickbooks Online - Report function - urlFragment parameter

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? 

Highlighted
Helper I
Helper I

Re: Quickbooks Online - Report function - urlFragment parameter

Lydia,

 

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

- Profit and Loss; and

- Balance Sheet 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors