Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Solved! Go to 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
I have connected the QB with BI but the following are missings.
1. GL table
2. Expense table
3. Reports function
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.
Hi!
I got an error while trying to connect. That's the message:
@timrodman,
I will consult this issue internally and post back once I get updates.
Regards,
Lydia
@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
/\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?
@timrodman,
Glad to hear the issue is solved. Could you please mark my reply as solution to close this thread?
Regards,
Lydia
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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
63 | |
61 | |
23 | |
18 | |
12 |