Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
I have a dataset connected to 9 folders on Azure Data Lake Gen1. The folders contain CSV files and each day it is stored a new one. Therefore we have programmed the refreshing every day, right after the new files are placed. The problem is that most of the time the refresh fails, throwing out the following message:
Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Unable to connect to the remote server"}}],"exceptionCulprit":1}}} Table: XXXXXXXXXXXXXXXX
Cluster URI: XXXXXXXXXXXXXXXXXXXXXXXXXXxx
Activity ID: XXXXXXXXXXXXXXXXXXXXXXX
Request ID: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Time: 2020-04-18 08:46:56Z
It doesn't work using the manual refresh neither, and the table that supposedly throws the error, change from one refresh to another.
If I try to refresh the data in PBI desktop it works perfectly every single time.
Does anyone know how to fixed it?
Thank you
Hi @RMM2C ,
There are several points you may considerate:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
I tried everything you say and still can't access the files. However, one of the times, the refreshing error change. Now I have two.
1st
{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Unable to connect to the remote server"}}],"exceptionCulprit":1}}}
2nd
Unable to connect to the remote server. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
Hi @RMM2C ,
Maybe you can refer this issue hopes to help you:
https://community.powerbi.com/t5/Report-Server/SCHEDULED-REFRESH-ERROR/td-p/508373
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
I did enter the credentials online and doesn't work
Activity ID: 625160ee-1859-42bb-ab4a-616f5b3ffcf1
Request ID: c23c873a-aeb2-e300-df91-505814dbc6ab
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
34 | |
30 | |
18 | |
12 | |
8 |
User | Count |
---|---|
50 | |
36 | |
30 | |
15 | |
12 |