Reply
avatar user
Anonymous
Not applicable

Refresh Issues

I have built a dashboard that uses CDS as a database. I connected to it via dataverse. Now, I am not able to refresh my data. This is the error that I get:

NikolinaS_1-1660723515549.png

 

How can I fix this? And do I have to click refresh everytime something is changed in the database?

P.S. CDS frontend was built in Cavas App, so people can enter data there and it is stored in CDS with visualization in my dashboard.

1 ACCEPTED SOLUTION
AnkitKukreja
Super User
Super User

Hi! @Anonymous 

 

This is a SQL issue. Please work with your SQL team to see what the logs say at their end. Probably the SQL server is not allowed to connect, that's what the error states.

 

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

View solution in original post

2 REPLIES 2
avatar user
Anonymous
Not applicable

Will do that. Thanks for the advice!

AnkitKukreja
Super User
Super User

Hi! @Anonymous 

 

This is a SQL issue. Please work with your SQL team to see what the logs say at their end. Probably the SQL server is not allowed to connect, that's what the error states.

 

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)