cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
timrodman Regular Visitor
Regular Visitor

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
Moderator v-yuezhe-msft
Moderator

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
Moderator v-yuezhe-msft
Moderator

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.
timrodman Regular Visitor
Regular Visitor

Re: Quickbooks Online - Report function - urlFragment parameter

Moderator v-yuezhe-msft
Moderator

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

timrodman Regular Visitor
Regular Visitor

Re: Quickbooks Online - Report function - urlFragment parameter

Thank you. That worked!

Moderator v-yuezhe-msft
Moderator

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.
gabrieloba Frequent Visitor
Frequent Visitor

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

 

peterprism Frequent Visitor
Frequent Visitor

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.

tbarron2 Frequent Visitor
Frequent 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? 

mbuhary Frequent Visitor
Frequent Visitor

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
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 87 members 1,395 guests
Please welcome our newest community members: