Forum Discussion
Each data refresh gives different data results
Hi zikas,
Could you please share about your current Power BI desktop version? Check it under File->Help->About. Mine is 2.38.4491.282.
I created some test data under SQL server 2014 database and the refresh is ok at my side. If the Power BI desktop version you currently used is not the latest, then please download the latest version and see if issue insists.
If Version is OK, then enable the trace log under:
File->Options and Settings->Options->GLOBAL->Diagnostics, check the Enable Tracing check box, then refresh the data again. After that, open the trace log file location, upload the log file into OneDrive and post us the shared link here, we will help to take a look.
See my version.
By the way, could you please explain a bit about the "involves only the Reports" here, do you mean refreshing data under Power BI desktop will cause the report Visuals to behave differently?
Regards
v-micsh-msft Yes, I have installed the 2.38.4491.282 version.
I have enabled the trace and I have refreshed the data, in the traces I found these 3 Errors:
Error 1: EvaluationContainerMain/ExceptionHandler/HandleException,"Exception:
ExceptionType: System.Threading.AbandonedMutexException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message: The wait completed due to an abandoned mutex.
StackTrace:
at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)
at Microsoft.Mashup.Container.EvaluationContainerMain.WaitForParentExitThread(Object state)
at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)"
Error 2: EvaluationContainerMain/ExceptionHandler/HandleException,"Exception:
ExceptionType: System.IO.EndOfStreamException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message: Unable to read beyond the end of the stream.
StackTrace:
at System.IO.BinaryReader.FillBuffer(Int32 numBytes)
at System.IO.BinaryReader.ReadInt32()
at Microsoft.Mashup.Evaluator.StreamMessenger.Read()
at Microsoft.Mashup.Evaluator.ChannelMessenger.Read(MessageChannel channel)
at Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Read()
at Microsoft.Mashup.Evaluator.Interface.IMessengerExtensions.WaitFor[T](IMessenger messenger, Action`2 handler)
at Microsoft.Mashup.Evaluator.RemoteServiceEnvironment.CreateServiceProxies(IMessenger messenger, IRemoteServiceProxy[]& services)
at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)
at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)"
Error 3: EvaluationContainerMain/ExceptionHandler/HandleException,"Exception:
ExceptionType: System.Threading.AbandonedMutexException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message: The wait completed due to an abandoned mutex.
StackTrace:
at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)
at Microsoft.Mashup.Container.EvaluationContainerMain.WaitForParentExitThread(Object state)
at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)"Anyone has any suggestions? Thank you
Hi zikas,
mscorlib is one of the conponment of .Net Framework, any changes has been made regarding .Net framework? Take a repair or a re-install of .Net Framework on your system.
In addition, could you please share the full log here?
Regards
Hi v-micsh-msft
I seem to have a very similar issue as posted here.
SQL 2016 and Excel data sources. Every time I refresh, I get a different result set appearing on my reports. Some rows are missing, others seem to be duplicated. Each refresh yields a slightly different result set, and each time it is incorrect.
I created the model and handed over to a business user late November 2016 year. About 2 weeks ago the user reported that some historical results kept changing. I am not sure at which point exactly this issue started, but I am now troubleshooting the issue on Power BI Desktop version 2.42.4611.701 64-bit (January 2017), and getting this strange behaviour consistently. The user reporting the issue is running the November release, so it seems to be across different versions of PBI Desktop.
Can I go ahead and add to this post, or should I open another thread? I have the trace logs ready.
Regards
Ina
I am also having issue. Has anyone found the cause or a solution? I am on the latest version of the Power Bi desktop. The data in the query editor is fine and the same number of rows are returned, but everytime I click the Refresh button on the report I get a different result even though the underlying data and report has not changed.
This is indeed really annoying, I am facing same problem since last three day every single time I refresh it gives me different results L I am using Power Bi latest release September. Also using SQl Server 2012, I tried using SQL Server 2016 No change in behavior. Can someone please respond
I am also having this exact issue. It seems to appear when I'm using an SQL Stored Procedure and passing variables to it (the variables are taken from another table to allow the user to change them before execution). I also put some logging in the Stored Procedure and the 1st time the query is refreshed (after changing the variables) the Stored Procedure gets executed anywhere from 4 to 11 times and returns duplicates and missing data! Any subsequent refresh only executes the proc once. I've also captured the raw results before they are sent to Excel. All return the same results set with the same counts so it's defintely something Power Query/Excel is doing.
