I am trying to use the "BI export" with Power Bi.
I have followed the following page instructions:
So, what i have done is:
Make a connector to the web "https://www.wrike.com/api/v4/data_export" with my token:
After transforming the response obtained, I get the following:
These URLs have the following format:
Then, I try to connect (using a from web connector) to one of this URLs using an Authorization "bearer mytoken":
The problem is that I get an error message:
The message says...:
Not possible to connect
There was found an error while connecting.
Details: "The 'Authorization' header is only supported when connecting anonymously. These headers can be used with all types of authentication: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type , If-Modified-Since, Prefer, Referer "
So... What am I doing wrong?
Appart from that, how could I change the real value of the URL (that is going to change every day) to the value of the following table, similar to a variable name? I will have one table for each URL:
Thank you very much for your help,