Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is this even possible? Would like to be able to connect to an index to query its data. Reading the article below it seems it should be possible:
https://docs.microsoft.com/en-us/rest/api/searchservice/
But each time I attempt to connect to one of our indexes, and authenticate using "Web API", I get an error telling me "A web API key can only be specified when a web API key name is provided. I tried entering the key itself in the Key window and I have also tried entering the key name in the Key window but each time the same message appears.
@phydeauxman,
You can specify an API key name in the hearers area of Web.Contents using Advanced Editor. Please review the example in the similar thread below:
https://community.powerbi.com/t5/Desktop/Get-data-from-web-error-A-web-API-key-can-only-be-specified...
Regards,
Lydia
@v-yuezhe-msft appreciate the response. I read the thread you linked and still don't really understand how to make this work.
@phydeauxman,
Add a blank query in Power BI Desktop, then paste your M scripts into the Advanced Editor of the query. There is also a similar thread for your reference.
https://jessedotnet.com/2016/06/24/power-bi-connect-to-your-secure-api/
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.