Thanks for your response!
I am a novice. I am using the code generated by Power Query and then trying to edit based on information I found online. I've started with Excel and then hope to do the same in Power BI. I just can't get it to work and don't know if I'm even pursuing the right solution. I agree it's not the most efficient way to get the data. There is an ongoing project intended to get all of our NetSuite data (along with other independent systems) into a data warehouse. Unfortunately, due to budget constraints, my division is on hold until sometime next year so I only have Web Query to work with. If I could get this to work, it would save a lot of time even if that meant refreshing the data and stepping away for a few minutes while it refreshes.
Here is what I tried, but it still doesn't work:
let
Source = Function.InvokeAfter(() => Web.Page(Web.Contents("https://...")),#duration(0,0,5,0)),
Data0 = Source{0}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Data0, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Accounting Period: Name", type date}, {"Transaction Date", type date}, {"Transaction Type: Long Name", type text}, {"Document Number", type text}, {"Entity (Line): Name", type text}, {"Memo", type text}, {"Description", type text}, {"Source Document Description", type text}, {"Originating Document Number", type text}, {"Amount (Gross)", type text}, {"Department: Name", type text}, {"Category:Product: Name (Grouped)", type text}, {"Sales Channel: Name", type text}, {"Source Channel: Name", type text}, {"Region: Name", type text}, {"Subsidiary: Name", type text}, {"Campaign Expense Category: Name", type text}, {"Marketing Campaign: Name", type text}, {"Currency: Name", type text}, {"Item", type text}, {"Account Number", Int64.Type}, {"Account Name", type text}})
in
#"Changed Type"
