Forum Discussion
Data source error: We're sorry, an error occurred during evaluation.
Hi arify,
Thank you for your prompt response.
I'm actually using Source = Json.Document(Web.Contents(...)). I took you advice and placed the basic authentication header into Web.Contents and set Authentication type as anonymous so the basic authentication in the Web.Contents would be used.
Source = Json.Document(Web.Contents("https://api.url.com/",[Headers=[#"Authorization"="Basic ZZZZZZZZZ", #"Accept-Encoding"="gzip"]]))
Once again everything works in Power BI Desktop but when we upload it to Power BI (Web) and try and set up a refresh we recieve the below error.
Data source type:
Data source error: The 'Authorization' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, If-Modified-Since, Prefer, Referer
Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID: 9515d921-45ea-4cc7-b2db-cfb35b71ba14
Request ID: 161b99b8-32b5-da4f-df49-2c505f9ec77a
Time: 2016-05-01 02:19:26Z
I did try to setup the Authentication method in Power BI (Web) as anonymous but receieved the below error.
Activity ID: 9515d921-45ea-4cc7-b2db-cfb35b71ba14
Request ID: ef8f1d3c-4d9b-b6d0-470b-ad7c240eb7b8
Status code: 400
Time: Sun May 01 2016 13:14:54 GMT+1000 (AUS Eastern Standard Time)
Version: 13.0.1100.472
Cluster URI: https://wabi-australia-southeast-redirect.analysis.windows.net
Details: The credentials provided for the Web source are invalid.
I did see that you mentioned Web.Page in you previous message but I did not think it was applicable to this example.Please let me know if I was incorrect.
Thank you in advance for your assistance.
Can you try not putting Authorization headers in the option record, instead entering credentials in the prompt? (Still with Table.Buffer in there)
Hi arify,
Thank you for your response.
As you mentioned I have removed the Authorization headers and added the username and password for basic authrnication under the Data source credentials in Power BI (Web). These creditals are checked and accepted without error.
In your previous message you mentioned "Still with Table.Buffer". As I am using Json.Document(Web.Contents(...)) so I used List.Buffer instead as Table.Buffer created an error. Example below. If I have misunderstood your implementation of Table.Buffer please let me know.
Source = List.Buffer(Json.Document(Web.Contents("https://api.url.com/")))
Once again this works perfectly in the Power BI Desktop but when published to Power BI (Web) I am still getting the refresh error as before.
I have noticed that Microsoft has reported Power BI as Service degraded with the following message.
Current Status: Engineers investigated reports that workbooks published to Power BI via the "Connect" option are failing to refresh and determined that a code regression is causing the problem. Engineers are currently developing a solution to remediate impact. Once the solution has been developed, it will be tested to ensure it fixes the problem and subsequently deployed throughout the affected environment.
I'm wondering if this has been the problem all along.
Thank you in advance for your assistance.
Sorry, I should have said Binary.Buffer, not Table.Buffer. Other thing is, it needs to wrap Web.Contents.
Can you try Json.Document(Binary.Buffer(Web.Contents("https://api.url.com/"))) ?
Hi arify,
Thank you for your response and clarification.
I have made your recommended change by adding Json.Document(Binary.Buffer(Web.Contents("https://api.url.com/"))) and it works perfectly in Power BI Desktop but as soon as we publish it and try and refresh the data we recieveing the same error.
Data source error: We're sorry, an error occurred during evaluation.
Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID: 0c126fbf-e5da-453c-9af0-99108bdf2c25
Request ID: 783eec27-6501-6e8d-764e-2eed06eea470
Time: 2016-05-04 04:49:27Z