topic Re: Error after adding a custom column when loading rows in Developer

Error after adding a custom column when loading rows

sophiabkb — Wed, 13 Sep 2023 20:20:29 GMT

Hello everyone,

I am getting data from an API to build a dashboard.

Everything was working perfectly fine until I added two more column with API custom function that fetch data based on a column id.

I can visualise the data on Power Query but I have a red and white stripes bar. The error occurs when loading and says :

OLE DB or ODBC Error : an exception type Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenException was thrown.

I have tried to clear permissions and re enter the credentials but it didn't work. I am connecting with Basic Auth.

I hope someone can help me, I can't understand why it worked before regarding it's the same credentials as before.

lbendlin — Sun, 17 Sep 2023 01:31:08 GMT

Does it work again when you remove these columns/custom function?

sophiabkb — Tue, 19 Sep 2023 08:47:03 GMT

Yes, it does work when I take off the custom column.

I create Two custom columns with API request using the same column parameter is it because of this ?

lbendlin — Tue, 19 Sep 2023 10:43:46 GMT

Do you get "access forbidden" only for some of the API calls?

You could choose to remove rows with errors, or replace errors. But the correct approach would be to fix the errors.