https://community.fabric.microsoft.com/t5/Power-Query/Rest-API-with-Bearer-Token-issue-applying-with-Anonymous-Auth/m-p/3070442#M97656 <P>Thanks ams1, tis a very wierd one. Running the same query for several other tables has the same behaviour in that the data displaying in the power query editor then auth error on both Refresh Preview along with Close &amp; Apply.&nbsp; So true regarding the credentials! <span class="lia-unicode-emoji" title=":face_with_tongue:">😛</span></P> Wed, 08 Feb 2023 23:14:58 GMT Anonymous 2023-02-08T23:14:58Z https://community.fabric.microsoft.com/t5/Power-Query/Rest-API-with-Bearer-Token-issue-applying-with-Anonymous-Auth/m-p/3043871#M96622 <P>Able to connect to Cherwell REST API via power query using Bearer Token with Anonymous Auth Selected showing json data OK. When selecting close and apply failing to authenticate.</P><P>NB: Tested with both Get Data Invoke added and removed.</P><P>&nbsp;</P><P><img /></P><P><img /></P><P><img /></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 25 Jan 2023 22:19:42 GMT https://community.fabric.microsoft.com/t5/Power-Query/Rest-API-with-Bearer-Token-issue-applying-with-Anonymous-Auth/m-p/3043871#M96622 Anonymous 2023-01-25T22:19:42Z https://community.fabric.microsoft.com/t5/Power-Query/Rest-API-with-Bearer-Token-issue-applying-with-Anonymous-Auth/m-p/3069262#M97594 <P>The data you're seeing might be old and the token might have expired - did you press the Refresh Preview button?</P><P>&nbsp;</P><P>BTW: It would be nice to be able to put the Authorization token in the Credentials instead of hardcoding it in the query, right?&nbsp;<span class="lia-unicode-emoji" title=":grinning_face:">😀</span></P> Wed, 08 Feb 2023 14:26:07 GMT https://community.fabric.microsoft.com/t5/Power-Query/Rest-API-with-Bearer-Token-issue-applying-with-Anonymous-Auth/m-p/3069262#M97594 ams1 2023-02-08T14:26:07Z https://community.fabric.microsoft.com/t5/Power-Query/Rest-API-with-Bearer-Token-issue-applying-with-Anonymous-Auth/m-p/3070442#M97656 <P>Thanks ams1, tis a very wierd one. Running the same query for several other tables has the same behaviour in that the data displaying in the power query editor then auth error on both Refresh Preview along with Close &amp; Apply.&nbsp; So true regarding the credentials! <span class="lia-unicode-emoji" title=":face_with_tongue:">😛</span></P> Wed, 08 Feb 2023 23:14:58 GMT https://community.fabric.microsoft.com/t5/Power-Query/Rest-API-with-Bearer-Token-issue-applying-with-Anonymous-Auth/m-p/3070442#M97656 Anonymous 2023-02-08T23:14:58Z https://community.fabric.microsoft.com/t5/Power-Query/Rest-API-with-Bearer-Token-issue-applying-with-Anonymous-Auth/m-p/3070969#M97670 <P>Well, regarding using the Credentials manager for header Authorization there might be a quick-and-dirty-ish way, stay tooned.&nbsp;<span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> Thu, 09 Feb 2023 06:14:18 GMT https://community.fabric.microsoft.com/t5/Power-Query/Rest-API-with-Bearer-Token-issue-applying-with-Anonymous-Auth/m-p/3070969#M97670 ams1 2023-02-09T06:14:18Z https://community.fabric.microsoft.com/t5/Power-Query/Rest-API-with-Bearer-Token-issue-applying-with-Anonymous-Auth/m-p/3070981#M97671 <P>Sounds intriguing, thanks ams1!</P> Thu, 09 Feb 2023 06:25:08 GMT https://community.fabric.microsoft.com/t5/Power-Query/Rest-API-with-Bearer-Token-issue-applying-with-Anonymous-Auth/m-p/3070981#M97671 Anonymous 2023-02-09T06:25:08Z