Power BI Desktop Attempting to Parse Login Page Instead of Data After Supplying the Integration Link.

Problem

Attempting to use a Datameer integration link with Microsoft Power BI Desktop doesn't allow data to be retrieved. After defining the integration URL, the Web View shows the Datameer login page but it can't interact with it. This makes it impossible to retrieve the data as authentication can't be performed.

Cause

This is a bug/regression in the Microsoft Power BI Desktop. The Web View was previously used to authenticate, and the data would then be ingested. Even after updating the permissions of the query - Power BI Desktop incorrectly attempts to parse the login page as HTML data, rather than re-run the query and retrieve the data.

Workaround

The credentials passed with the query can be updated after building the initial query, the initial query deleted, and a new query built. At this point, the new query will properly pass credentials through the HTTP header with the query, and data will be retrieved.

1. In Datameer, right-click on your workbook and select Show Results.
2. Click Copy Integration Link in the Download dialog.
3. Open Power BI Desktop and select Get Data -> Other -> Web
4. Paste in your integration link retrieved in Step 1 and click OK.
5. Note, in the Table View it shows an HTML document.
6. Note, in the Web View you can see this HTML document is the Datameer Login screen correctly challenging for authentication.
7. Click on the Menu Button above the Power BI Desktop Ribbon and select Options and Settings -> Data source settings.
8. Click the URL shown in the Edit Data Source window and then select Edit Permissions...
9. Under Type: Anonymous click Edit... and select Basic Authentication from the list on the left.
10. Enter your Datameer credentials, and click Save.
11. On the Ribbon Home Tab click Edit Queries.
12. In the Query Editor right click on the Document in the Queries pane and Delete the query, then Close & Apply.
13. On the Ribbon Home Tab click Get Data -> Other -> Web and re-add your Integration URL.
14. Since credentials have been pre-set for this source, they will be passed through to Datameer in the request header and the login page will be bypassed.