Authentication error when trying to get dynamic refresh token using Power Query

atharsana — Fri, 01 Mar 2024 13:26:26 GMT

Hi Community,

I am connecting my data through Web(using advanced section) in PowerBi. The data can be fetched using the Bearer type access token generated from postman. Since the Access token is valid only for short period of time, I have used a query to have the refresh token dynamic.

But on applying the query, it throws a error like cannot authenticate with credentials provided, despite the credentials given are correct. Also it says the data can only be fetched by Anonymous method.

Help me to overcome this error
Thankyou

Re: Authentication error when trying to get dynamic refresh token using Power Query

Anonymous — Mon, 04 Mar 2024 03:52:49 GMT

Hi atharsana

What is your data source?

Maybe you can try other types of Authentication, like windows or organizational account.
If the above one can't help you, could you please provide more detailed description of your connection flow.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: Authentication error when trying to get dynamic refresh token using Power Query in DAX Commands and Tips

Authentication error when trying to get dynamic refresh token using Power Query

Re: Authentication error when trying to get dynamic refresh token using Power Query