Forum Discussion
Data in SQL Updating but Not Reflecting in Report Visuals – Translytical Flow Issue id
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
Hi Mohan128256,
How is your report connected to the Lakehouse? Are you using Import mode, DIrectQuery, or DirectLake?
If you're using import mode, then you will also need to refresh the semantic model. You can do this manually, schedule it, or add a semantic model refresh activity to a pipeline.
A common pattern here is using a pipeline to run your dataflow, and then once the dataflow is completed, run the semantic model refresh.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Hi tayloramy
Dataflow Gen2 (Microsoft Fabric)
Set up a Dataflow Gen2 in Microsoft Fabric to automatically pull data from the SharePoint site:
The Dataflow connects to the SharePoint Folder source, transforms the CSV file, and loads it into the SQL table. (Here i have given destination as my SQL database(This sql database i have creaed in fabric)). I have checked the SQL database by running the table name i can see the data.
Then i have followed microsoft translytical link
I haven’t missed anything.I have implemented this before in the same report without issues. Now, I’m facing a problem with the lakehouse.
I created a report catalog table using SQL, and it works fine; updates are happening correctly. However, in the current report, I’m seeing issues. Previously, when I implemented Report Catalog in the same report, it asked whether to use Direct or Import mode, and I used Direct Select.
Now, after bringing the table into the Lakehouse, it’s not asking for Direct or Import — I just loaded it, and I implemented it via Translytical.
So this is how i implemented.