Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
107 | |
106 | |
91 | |
67 |
User | Count |
---|---|
162 | |
133 | |
132 | |
93 | |
91 |