Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, everybody. This board has been a tremendous help to me in troubleshooting Power BI issues.
In looking at this post earlier, as well as the API documentation, I was able to ascertain how to run QBO reports using a Blank Query. For instance, this query for a balance sheet is successful:
= QuickBooks.Report("/reports/BalanceSheet?accounting_method=Cash&date_macro=All&summarize_column_by=Month")
However, this query for vendor expenses is not successful:
= QuickBooks.Report("/reports/VendorExpenses?accounting_method=Cash&date_macro=All&summarize_column_by=Month")
Even though it seems to be appropriate given the API documentation:
When I run the "Expenses by Vendor Summary" report in QuickBooks Online, I get plenty of data as expected.
Any ideas as to what would cause my query to return no data? This also happens with several other reports, like Customer Income. I can pull a balance sheet and P&L, though.
Thanks!
Hi @Anonymous ,
You may need to make sure the arguments in URL for BalanceSheet are effective or existed in VendorExpenses.
In addition, you may get the QuickBooks Online data from the AppSource, see more: Connect to QuickBooks Online with Power BI.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the response @v-xicai. However, that unfortunately doesn't answer my question.
In addition, you may get the QuickBooks Online data from the AppSource, see more: Connect to QuickBooks Online with Power BI.
I need to be able to marry QBO data with non-QBO data, and the app doesn't allow for that.
You may need to make sure the arguments in URL for BalanceSheet are effective or existed in VendorExpenses.
Good point. I should have mentioned in my first post that I confirmed the arguments I'm using in my VendorExpenses query are also present in the BalanceSheet query and appropriate, per the API documentation.
Any other ideas? Thanks in advance.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |