none
JSON Query - DataSource.Error: Web.Contents with the Content option is only supported when connecting anonymously. RRS feed

  • Question

  • I'm trying to read some JSON data with a POST (Content=Text) query from a https source where authentication is required.

    There are a number of old posts saying that it is not possible to authenticate with this type of query.  Is this still the case?

    thanks.

    Power BI version Version: 2.40.4554.161 32-bit in Excel Pro Plus 2010 32-bit.


    • Edited by adnerwm Wednesday, February 8, 2017 7:11 AM
    Wednesday, February 8, 2017 7:09 AM

Answers

  • It might work: You create your query using your API-key.

    When you execute the query you will be asked by Power Query how you want to connect. There you will have to choose anonymus - but this will mean that your API-key will be used when connecting to the source.


    Imke Feldmann TheBIccountant.com

    Wednesday, February 8, 2017 9:59 AM
    Moderator