Forum Discussion

Nari1998's avatar
Nari1998
Helper II
2 years ago
Solved

There was an error when processing the data in the dataset.

Hi, I noticed that refreshed in the desktop version gives no error and even to publish normally, however when the scheduled or manual refresh is done is get the following error in power bi service: ...
Need Help
  • Nari1998's avatar
    Nari1998
    2 years ago

    Hi all lbendlin and Anonymous , thank you for the reply, it just seemed to be a credential issue by which i had to edit the credentials for web in power bi service and then the issue was fixed 

snehal123's avatar
snehal123
New Member
1 year ago

Last refresh failed: 11/18/2024, 11:07:26 AM
There was an error when processing the data in the dataset.Hide details

Data source error:{"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"Cloud data source refresh is not allowed in gateway setting."}}],"exceptionCulprit":1}}} Table: SalesRegisterTbl.
Cluster URI:WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID:9ce895e7-3425-4cb1-a6fe-298f838cbfa4
Request ID:cd20fe3c-44c5-758e-5231-b84fd71f3d12
Time:2024-11-18 05:37:26Z

 

im facing this error can anyone help me out for this i have published dashboard in bi service and data contains from 2 diffrent server and five excel files from sharepoint 
and i have setup geteway only for sql server dataset but still getting this error

Error

 

Data source error: {"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"Cloud data source refresh is not allowed in gateway setting."}}],"exceptionCulprit":1}}} Table: SalesRegisterTbl.

 
how to solve it