We have used the Power BI desktop to create a report. The report data source is an external API which requires basic authentication. We have no problem refreshing the data in the Power BI desktop application. However, when we publish the Dataset and try and to refresh the data in the Power BI (web version) we recieve the follow error.Data source type:Data source error: We're sorry, an error occurred during evaluation.Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.netActivity ID: 653d7ecf-b95b-4105-9c56-48bf924b65baRequest ID: ec081686-aa7b-d995-95ad-d7615ab97687Time: 2016-04-29 01:01:38Z We have reentered the Data Source credentials to ensure that is not the issue. 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.

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.netActivity ID: 0c126fbf-e5da-453c-9af0-99108bdf2c25Request ID: 783eec27-6501-6e8d-764e-2eed06eea470Time: 2016-05-04 04:49:27Z

When you say 'publish', do you mean Power BI Service? If that's the case (works in PBI desktop, but not in PBI Service) can you open a ticket on the PBI Service website?

Data source error: We're sorry, an error occurred during evaluation.

19 Replies

Amanda-Lee
New Member
3 years ago
Hi,

I get this error when I try to refresh a dataset. My data is on a MySQL server. The data gets puled into my Power BI report via SQL queries. I created the report in Power BI desktop and uploaded it to PowerBi online version so my collueges could use it as well. I have been using this report for months without issue, until this morning.

I am working on the latest version of datagateway and my dataset is linked to my gateway.

I have no idea wat to do further. Please help.
ankitpatira
Community Champion
10 years ago
gstuart which connector under Get Data have you used in powerbi desktop ?
- gstuart
  Regular Visitor
  10 years ago
  I used the Web connector.
  - arify
    Microsoft Employee
    10 years ago
    Hi,
    Web.Page doesn't apply Basic Authentication (because of security reasons we've disabled it). But, you can use it in Web.Contents.
    
    Your query is probably shaped like this: Web.Page( Web.Contents( ...) )
    Try adding Table.Buffer in the between:
    Web.Page( Table.Buffer( Web.Contents( ...) ) )
nakia
Frequent Visitor
10 years ago
Hi, I was wondering if you could elaborate on the solution for this problem.

I having the exact same error occur and I have tried wrapping the Web.Content in Binary.Buffer as suggested and am still getting the same error occur.
- arify
  Microsoft Employee
  10 years ago
  Hi,
  
  That sounds like a different issue, we need someone else's input on that, sorry :/
  - hina
    Frequent Visitor
    9 years ago
    i am getting this error when i am trying to refresh the access db dataset using personal gateway. I have installed both 32bit and 64 bit redistributble engine for MS access
    can anyone please help?

Forum Discussion

Data source error: We're sorry, an error occurred during evaluation.

19 Replies

Related content

Vague Refresh Failure message: We're sorry, an error occurred during evaluation

error "We're sorry, an error occurred during evaluation."

Error on Service - Works on Desktop - We're sorry, an error occurred during evaluation

Error message when evaluating data flow: An error occurred while communicating with another service

Data source error: We're sorry, an error occurred during evaluation.