Custom Fields in QuickBooks

[ctedesco3307]

Hi All – trying to use the QuickBooks  Beta connector to report on my QuickBooks data. I created some custom fields for my estimates, I thought the  connection from the Estimate_CustomField table would show me those fields but the values I get from that are not the custom values I set up for Estimates.

Does anyone know where / if I can get these fields into PBI?

Thanks in advance

[v-yiruan-msft]

Hi @ctedesco3307 ,

Please review the following links, hope they can help you.

Convert Rows to columns

Power BI: Pivot and Unpivot Columns

Retrieve Custom Fields

Data in Custom Fields not showing in report

Best Regards

[ctedesco3307]

Thanks for the response but no, none of these are what I'm looking for I'm using the QB Beta connector in PBI, not running QB reports. Not sure what the Pivot tables as to do with it. Looking at the QB API is not a bad idea though, but I have the connector in use for my other tables so wasn't sure why I was not seeign expected results in this one.