Forum Discussion
Data source error: We're sorry, an error occurred during evaluation.
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:27ZWhen 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?
I'm glad I could help :)
arify could you post solution for this problem please. We are expreincing the same issue.
Hi dstramilov, the solution is already in this thread :) http://community.powerbi.com/t5/Integrations-with-Files-and/Data-source-error-We-re-sorry-an-error-occurred-during/m-p/32796/highlight/true#M3489
Basically, you need to wrap your Web.Contents call with Binary.Buffer like my example in that reply.
I was able to publish one queries, but if I add several queries to datasaet I am getting error.
In Desktop version it works perfectly. I am using Function to get AuthKEY and pass it to each queries to get data.
I found out that Function is not supported when we publish report & schedule refresh.
