I have a BAQ in Epicor with two parameters. I can call it from Postman and Swagger Help without a problem. I can also call it from Postman without a problem. But I cannot get it to work in Power Query Editor from Excel. I have an API created and the BAQs are assigned to the scope. The scope is appl…

Try this: [image] // p function let Source = (paramName) => (Excel.CurrentWorkbook(){[Name=paramName]}[Content]{0}[Column1]) in Source // ODataCall Info let // Encode Basic Authentication manually (username:password in Base64) : Change appropriately Base64Auth = "Basic " & Binary…

REST API, Postman, and Excel Power Query Editor

Kinetic ERP

CSmith (Clint Smith) February 4, 2025, 6:47pm 2

Try this post

2 Likes