Hi all
In the absence of an official connector for PowerBI, how can I add a connection to PowerBI manually so that I can simply use the API to access the data?
I have tried the following:
- Setting up an "Anonymous" PowerBI connection and sending the following with the URL:
- Setting up an "API Key" PowerBI connection with the same...
- When it asks for the API Key in the "Authentication Type" window, it replies with "Can't use an API Key without an API key name" - but nowhere does it ask for one
- Setting up a "Windows Authentication" connection using the same account which single-signs-on to SWSD in our organisation
In all cases which get beyond the Authentication Type screen, I am sent back a "406" error - "Unacceptable".
No idea what that means.