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?


    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


  • 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

    Wednesday, February 8, 2017 9:59 AM