Forum Discussion

Mohan128256's avatar
Mohan128256
Helper IV
9 months ago
Solved

Data in SQL Updating but Not Reflecting in Report Visuals – Translytical Flow Issue id

Hi everyone, I’m facing an issue where the backend SQL data is updating correctly in the Lakehouse, but the changes are not reflecting in the report visuals. Here’s the setup I followed: Created...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • Mohan128256's avatar
    Mohan128256
    9 months ago

    Hi v-saisrao-msft tayloramy 

    The issue has been resolved. I created a new dataset and connected it with SQL, and it’s working now. Thanks a lot for your help 

tayloramy's avatar
tayloramy
Super User
9 months ago

Hi Mohan128256,

 

When connecting to the Lakehouse table, did you use the SQL endpoint connection string method, or did you do it from the OneLake Catalog?  

 

You mentioned both SQL databases and Lakehouses, which are you using? Or are you using both? 

 

After the dataflow runs, have you validated that data in the database or lakehouse is updated? 

 

This will help us troubleshoot if the issue is with the dataflow, or if it's with the connection between the data and the semantic model. 

 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.