Solved: Refresh Issues

Anonymous · ‎08-17-2022

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:

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.

AnkitKukreja · ‎08-17-2022

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

Anonymous · ‎08-17-2022

Will do that. Thanks for the advice!

AnkitKukreja · ‎08-17-2022

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