Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Yesterday I updated PBI Desktop, made some changes to 5 reports and republished them all. Of the 5 reports re-published 4 of them are set to use refresh schedules. The refresh started out ok but since then 2 of the changed reports (plus another one I haven't changed) started to fail to refresh beginning around 5 hours ago.
The error I get is "The last refresh attempt failed because of an internal service error."
Technical Information:
Activity Id: 2f9c5f94-7f1d-48ee-bf5d-cb39a0656c23
Request Id: 0aab327c-e8c3-49e3-81ba-6ae66493025b
Cluster Name: WABI-WEST-US-redirect.analysis.windows.net
Refresh Start Time: 03/22/2018 13:01:14Z
Refresh End Time: 03/22/2018 13:06:02Z
I've tried republishing the failed reports again (which worked on another thread) but this doesn't help. I've resubmitted data source credentials in the refresh schedules, this also doesn't work.
Any suggestions on what to try next?
Solved! Go to Solution.
thanks @v-jiascu-msft - I did just that. The support desk were very helpful.
The solution in my case was to remove the broken reports from the Online service and re-add them.
1 - Open the report(s) in PBI Desktop and clear the cache (file...options and settings... options)
2 - Refresh the data in the desktop and save.
3 - Open PBI Online and remove the associated dataset(s). Note - you'll need to remove the reports from any content packs before you can remove the reports and data from the online service. Also you might want to make a note of the (failed) refresh schedule you had before doing this so you can recreate it exactly.
4 - Hop back to PBI Desktop and publish the report from PBI Desktop to Online
5 - Hop back to PBI Online and set the refresh schedule back up
6 - Add the reports back into any apps or content packs.
Hope that helps.
This worked for me also. I wish it wasn't necessary, but glad to get around it.
No idea.
I've had the same issue several times this week.
This simply isn't good enough.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
22 | |
17 | |
10 | |
8 | |
7 |
User | Count |
---|---|
42 | |
28 | |
18 | |
17 | |
15 |