Forum Discussion
Transactions not showing fully despite successful data refresh
Hello, I have a problem in the scheduled update of transactions in a transaction table of my Power BI dataset. Users report to me that some transactions are missing from their Power BI reports despit...
This question has never been answered. I still have the same problems and it's mainly for my transaction table.
The way I found to solve this automated refresh problem is really annoying.
1 - Each time I have to download the dataset locally.
2 - I make sure to clear the cache (I'm not sure it makes a difference but I'm not taking a chance)
3- I update locally and then I publish in the workspace.
When I have completed these 3 steps, I am able to see the transactions.
Could the commandtimeout at 1 hour 30 minutes be the problem or the pro license I have? Does the cache have a physical limit on the service?