Ghost records showing up in Power BI

[cnpdx]

Hello,

I have an integration between Power BI and QuickBooks Enterprise, using the QQUBE tool as a connector. It has worked fine for a long time, and I have developed a very mature model for a company. Recently, ghost records have shown up in the Power BI model that don't actually exist in QuickBooks. Any ideas? Here is some background:

A batch of invoices was entered into QB, and then subsequently deleted. Those records do not affect financials in QB, and literally, do not exist using any search parameters, but when I refresh my Power BI model, the records show up. The (ghost)dollar amount is so large that the model is basically unpresentable at this point. Here are some steps I have taken to try to fix, to no avail:

1) I have gone back to an older iteration (many different ones, from many different months) of the .PBIX file, and refreshed data from there, the same thing happens.

2) Within QB, I have used utilities such as "verify data", "rebuild data", "sort lists", and round tripped to a portable file. Nothing has fixed the problem. 

If you have any ideas on a solution, it would be greatly appreciated!

[v-qiuyu-msft]

Hi @cnpdx,

It seems that you utilize the QQube to import QuickBooks data to Power BI desktop. Currently Power BI desktop has a QuickBooks online connector which is beta, you can try this connector. Also please remember to update the Power BI desktop to the latest version 2.45.4704.722.

Best Regards,
Qiuyun Yu

[djnww]

This sounds like a QuickBook problem rather than PowerBi. QuickBooks obviously still keeps those ghost records. I am assuming for audit purposes.

Hence, you'd hope there should be a 'delete' flag of some sort for you to exclude them upon import. I'd probably raise the matter with Quickbooks.

Dan