Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Recently i've been running into this issue where I am unable to schedule refresh or refresh my data from the Power BI online client.
My dashboards are connected to SQL and it has worked before. However now I keep getting the error message below when trying to refresh:
Last refresh failed: Tue Aug 14 2018 08:33:06 GMT+0800 (Singapore Standard Time)
There was an error when processing the data in the dataset.Hide details
Data source error: | The command has been canceled.. The exception was raised by the IDbCommand interface. |
Cluster URI: | WABI-WEST-US-redirect.analysis.windows.net |
Activity ID: | 9712ab71-9fbe-4939-b630-2b57c28fd182 |
Request ID: | fe788762-9ff6-484c-44ea-eedc6228eec1 |
Time: | 2018-08-14 00:33:06Z |
my gateway is an on premise data gateway (not personal) version number: 14.16.6697.
can anyone highlight what this EDbCommand interface actually does and why is there an exception raised by this module?
Much thanks
Solved! Go to Solution.
Hi @Anonymous,
Based on my reserch, you coyld refer to below question.
1. Can you refresh your data in dashboard? If not, can you provide the error message that showed up in the Desktop?
2. How many queries (tables) in your model? Maybe some queries need much longer time to refresh.
3. Can you carry out a manual refreshing in the Service successfully?
Please reference to these threads, maybe helpful.
Error-refreshing-The-command-has-been-canceled
Schedule-Refresh-Processing-Error
Regards,
Daniel He
Hi @Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
My solution was to update the data gateway which seemed to fix the problem
Hi @Anonymous,
Based on my reserch, you coyld refer to below question.
1. Can you refresh your data in dashboard? If not, can you provide the error message that showed up in the Desktop?
2. How many queries (tables) in your model? Maybe some queries need much longer time to refresh.
3. Can you carry out a manual refreshing in the Service successfully?
Please reference to these threads, maybe helpful.
Error-refreshing-The-command-has-been-canceled
Schedule-Refresh-Processing-Error
Regards,
Daniel He
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |