Forum Discussion
Solved
Power BI Desktop connection QuickBooksOnline cannot pull data from Invoice_Sales_Item_Line
Would love it if someone has an idea about this one. I am trying to set up a connection via PowerBI Desktop to Quickbooks Online to pull the line items of invoices (ideally for the last 3 years only...
To my knowledge you cannot filter Quickbooks data before the import like you can with SQL Server and OData feeds. Power Query would need to process all of the data. You can then filter in Power Query and only bring the 3 year range into the DAX model. But Quickbooks like like a CSV file in that regard. Power Query has to do all of the work.
To my knowledge you cannot filter Quickbooks data before the import like you can with SQL Server and OData feeds. Power Query would need to process all of the data. You can then filter in Power Query and only bring the 3 year range into the DAX model. But Quickbooks like like a CSV file in that regard. Power Query has to do all of the work.
Thank you. I will cease looking for a solution on this path then.