Forum Discussion

Tekell09's avatar
Tekell09
Frequent Visitor
2 years ago

Quickbooks Online to Power Query

Currently, I have setup a schedule to deliver a custom report from Quickbooks Online to my OneDrive. It is an .xlsx file. I have copied the web path of the file and am using a Web Connection with the...
Need Help
Tekell09's avatar
Tekell09
Frequent Visitor
2 years ago

Thanks for your reponse. The data formatting is "custom" ( ...in the.xlsx file ) when it comes over from QuickBooks Online. When I manually change it from "custom" to "general" it fixes the issue. However, I can't make this manual change daily.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Does Power Query Editor generate an auto "Changed Type" step after connecting to this Excel file? If removing this step, will it get the correct data?