Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

etiennehm

Azure SQL server Dataset can't refresh

Submitted by on ‎05-11-2021 07:45 AM

Last refreshes failed for my Dataset, for approximately a month: The last refresh attempt failed because of an internal service error.
Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
Activity ID: 5fe2670d-dfb9-4b45-869e-398e8abd5ff3
Request ID: ba6b39dd-326c-507d-bfd4-7cf446e03a80
Time: 2021-05-11 14:32:56Z

 

What is there to do? It's connected to an Azure SQL server and the credentials are fine. A firewall exception had been added and it was all working fine before.

 

Thanks!

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-lili6-msft
Community Support
Community Support
‎05-12-2021 11:47 PM

hi

If you could refresh it in power bi desktop?

or try to re-edit the data source credentials for this dataset then try it again.

 

Regards,

Lin

etiennehm
New Member
‎05-13-2021 11:47 AM

Hi,

 

Thanks for your reply! Opening it on Power BI Desktop and refreshing the data revealed an issue with a many-to-one relationship (from a corrupted entry). I could fix the issue in the database; the dashboard is back up and running!

This would have saved so much time if we had the error message directly in the "detailed" refresh message, instead of a generic error that means nothing...

 

Anyway, thanks for the help!

Idea Statuses