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.
I have a Power BI reports linked to a SharePoint list.
When I refresh the data in Power BI desktop (either in the main interface or in the query editor) it works fine. However the scheduled refresh always fails. Can anyone give me a clue what might be the issue? Here is a message the was provided:
Last refresh failed: Thu Jul 12 2018 00:17:38 GMT+0100 (British Summer Time)
There was an error when processing the data in the dataset.Hide details
Message: The command has been canceled. Table: Contractors & Employees.
Cluster URI: WABI-UK-SOUTH-redirect.analysis.windows.net
Activity ID: 17fbb279-de52-471c-bee6-d9107d973da9
Request ID: 49347876-adc5-41d4-9f62-6cfa6e6755e4
Time: 2018-07-11 23:17:38Z
Solved! Go to Solution.
check if you have calculated column with error in the table "Contractors & Employees" or if you have measure with a problem that used data from that table
check if you have calculated column with error in the table "Contractors & Employees" or if you have measure with a problem that used data from that table
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |