Forum Discussion
Data source error: We're sorry, an error occurred during evaluation.
Microsoft EmployeeSorry, 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
- arify
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?
- arify
I'm glad I could help :)
dstramilovHelper II
arify could you post solution for this problem please. We are expreincing the same issue.
- arify
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.
- dstramilov
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.