Forum Discussion
Scorecard Semantic Model Errors on Refresh - help needed!!
Hi all
Hoping you can help because Microsoft's support/product teams have been less than helpful. I have a scorecard with 1229 goals that we use for all types of reporting at my organisation. It is 2.5 years old - so lots of historical data, and it's been working just fine. On the 8th July the semantic model for the scorecard stopped refreshing with the error below. Nothing I can do seems to get it working. I could recreate the scorecard but I really dont want to lose all the historical data that we've built up and we actively need it for our reporting requirements (to be able to show historical information and trends). All my other scorecards (I have 9 or 10) are absolutely fine. It's literally just this one - which of course if the biggest and oldest one!!
Because the semantic model is created by Microsoft when you create the scorecard, it's not something I've created. I have a case open with them and their response has essentially been: "Sometimes they just break and we don't know why. the goal connector in powerquery online isn't supported. There's nothing we can do." - which frankly is wild. In the error below the Table which is raising the exception seems to change but the rest of it is always the same. I don't understand how the goal connector isn't supported on a feature they've made publicly available -- and again, all my others are working just fine.
Does anyone have any bright ideas so that I don't lose 2.5 years worth of data? Please help!!
Error:
Data source error: DataSource.Error: Web.Contents failed to get contents from 'https://api.powerbi.com/v1.0/myOrg/internalScorecards(<scorecardID>)?$expand=goals($expand=aggregations,goalValues($top=2147483647;$expand=notes))' (400): Bad Request. Microsoft.Data.Mashup.ErrorCode = 10117. DataSourceKind = Goals. DataSourcePath = Goals. Url = https://api.powerbi.com/v1.0/myOrg/internalScorecards(<scorecardID>)?$expand=goals($expand=aggregations,goalValues($top=2147483647;$expand=notes)). . The exception was raised by the IDbCommand interface. Table: Statuses.
Cluster URI: WABI-NORTH-EUROPE-G-PRIMARY-redirect.analysis.windows.net
Activity ID: <redacted>
Request ID: <redacted>
Time: 2025-08-11 11:01:23Z
Hi, I just wanted to give an update - I did escalate the ticket but didn't get any information. However, I have managed to fix it. Whatever error happened to the scorecard, when i started removing goals and got it to under 1000 goals, it started to work. So I have gone through and copied the scorecard multiple times with all check-in history, and created groups of goals that will make sense - so instead of one scorecard with 1229 goals, I have now have 5 scorecards all with some goals.
I think the main takeaway for this is to make sure you don't go over 1000 goals. I know MS haven't actually specified any limit on the number of goals, but it seems to make a difference. The refresh is now working absolutely fine for the 5 scorecards.
So after reopening the ticket and having many conversations, the upshot is that they don't really know and the scorecard is too big to 'troubleshoot properly' (their words). They tried telling me that the goal limit for a scorecard is 1000, but I have a second scorecard with 1190 goals in it and that hasn't broken. I'm not 100% sure what has happened, but the big one with 1240 goals in it hasnt started working again.
That said, I used their new feature to 'copy scorecard' with history, multiple times, and then reduced the scorecards down to logical groupings - i.e. if I had groups A, B, and C within the big scorecard, i've grouped A and B into a new scorecard, and C has gone into a second scorecard - this has reduced the number of goals per scorecard and the refresh is now working again. I also found that removing any special characters such as quotes, / and hyphens has improved the stability of the refresh. it does mean I need to manage more scorecards, but at least they aren't breaking and i can get to the data now.
MS weren't able to explain why my scorecard with 1190 goals is still functioning, though they have stated they think the limit is 1000 and will update the documentation accordingly. I am planning on splitting out the other big one in the same way I've done the broken one, just to minimise the chance it may break in future.
Hope this helps someone else!!
6 Replies
There is an issue with an API
Please open a support ticket starting from here
https://admin.powerplatform.microsoft.com/
They will support you very quickly
I understand you already tried to get support, did you already follow this route for the support?
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
So, as I said in my original post, I have already opened a ticket with Microsoft. After 3 weeks, their official statement was "the scorecard capability isn't supported in power query online. Sometimes they break and we don't know why. All you can do is rebuild it as a new scorecard which will mean you'll lose all the historical data".
So I came here because after an awful response from MS yesterday, I was hoping someone else had come across this problem and somehow found a fix.I am very sorry to know that was the answer, I was suggesting to reopen the ticket and see if you get better support. I hope someone else can help here but honestly I doubt that anyone can do more than Microsft technicians.
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hi, I just wanted to give an update - I did escalate the ticket but didn't get any information. However, I have managed to fix it. Whatever error happened to the scorecard, when i started removing goals and got it to under 1000 goals, it started to work. So I have gone through and copied the scorecard multiple times with all check-in history, and created groups of goals that will make sense - so instead of one scorecard with 1229 goals, I have now have 5 scorecards all with some goals.
I think the main takeaway for this is to make sure you don't go over 1000 goals. I know MS haven't actually specified any limit on the number of goals, but it seems to make a difference. The refresh is now working absolutely fine for the 5 scorecards.
So after reopening the ticket and having many conversations, the upshot is that they don't really know and the scorecard is too big to 'troubleshoot properly' (their words). They tried telling me that the goal limit for a scorecard is 1000, but I have a second scorecard with 1190 goals in it and that hasn't broken. I'm not 100% sure what has happened, but the big one with 1240 goals in it hasnt started working again.
That said, I used their new feature to 'copy scorecard' with history, multiple times, and then reduced the scorecards down to logical groupings - i.e. if I had groups A, B, and C within the big scorecard, i've grouped A and B into a new scorecard, and C has gone into a second scorecard - this has reduced the number of goals per scorecard and the refresh is now working again. I also found that removing any special characters such as quotes, / and hyphens has improved the stability of the refresh. it does mean I need to manage more scorecards, but at least they aren't breaking and i can get to the data now.
MS weren't able to explain why my scorecard with 1190 goals is still functioning, though they have stated they think the limit is 1000 and will update the documentation accordingly. I am planning on splitting out the other big one in the same way I've done the broken one, just to minimise the chance it may break in future.
Hope this helps someone else!!
