Forum Discussion

davideigner's avatar
davideigner
New Member
3 years ago

QuickBooks Online Custom Fields

It sounds like the QuickBooks Online connector doesn't import custom fields.   Did anyone notice that? Any workaround?
Need Help
Tips and Tricks
Shaurya's avatar
Shaurya
Memorable Member
3 years ago

Hi davideigner,

 

You can go to the advanced editor in Power Query and edit the source.

 

let
    Source = QuickBooks.Tables(),
in
    #"Source"

 

Just removed online from it. This lists all the tables that are otherwise omitted.

 

Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI

  • davideigner's avatar
    davideigner
    New Member
    3 years ago

    Shaurya This is what I have now, do I need to update anything?

     

      • davideigner's avatar
        davideigner
        New Member
        3 years ago

        Thanks Shaurya.

         

        When I change to "Source = QuickBooksOnline.Tables()" nothing changes.

        When I change to "Source = QuickBooks.Tables()," I'm getting the following error.