Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

After August 2018 update Power Bi desktop does not work

Submitted by Anonymous on ‎08-11-2018 05:58 AM

I uninstalled previous version, removed Power Bi folder from Users directory and Installed August 2018 update. 

I can`t open pbix files, I cant enter data directly into pbix file or source it from excel. I can`t save PBIX files either. Here is a couple of logs

 

Log 1 when tried to open a pbix file

 

bjectCacheSessions/CacheStats/Size {"Start":"2018-08-11T11:47:36.4967412Z","Action":"ObjectCacheSessions/CacheStats/Size","entryCount":"1","totalSize":"24","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":720,"Tid":14,"Duration":"00:00:00.0049620"}
ObjectCacheSessions/CacheStats/Access {"Start":"2018-08-11T11:47:36.5063807Z","Action":"ObjectCacheSessions/CacheStats/Access","hits":"0","requests":"1","hitrate":"0","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":720,"Tid":14,"Duration":"00:00:00.0001016"}
RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-11T11:59:33.3172312Z","Action":"RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"720","identity":null,"evaluationID":"1","containerID":"1","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"c2cb713e-57fb-45aa-b3b9-32d184883644","Process":"PBIDesktop","Pid":720,"Tid":18,"Duration":"00:00:09.4303279"}
DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-11T11:59:33.1956961Z","Action":"DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"c2cb713e-57fb-45aa-b3b9-32d184883644","Process":"PBIDesktop","Pid":720,"Tid":18,"Duration":"00:00:05.0865256"}
RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-11T11:59:45.0693246Z","Action":"RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"720","identity":null,"evaluationID":"2","containerID":"1","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"9d3becab-0c6d-4c39-9419-5bb1055a0e61","Process":"PBIDesktop","Pid":720,"Tid":18,"Duration":"00:00:11.1053277"}
DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-11T11:59:45.0683572Z","Action":"DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"9d3becab-0c6d-4c39-9419-5bb1055a0e61","Process":"PBIDesktop","Pid":720,"Tid":18,"Duration":"00:00:00.0156653"}

 

Log 2 when tried to open excel file

ObjectCacheSessions/CacheStats/Size {"Start":"2018-08-11T11:59:37.8485160Z","Action":"ObjectCacheSessions/CacheStats/Size","entryCount":"1","totalSize":"24","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:00.0110290"}
ObjectCacheSessions/CacheStats/Access {"Start":"2018-08-11T11:59:37.9079357Z","Action":"ObjectCacheSessions/CacheStats/Access","hits":"0","requests":"1","hitrate":"0","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:00.0000917"}
SimpleDocumentEvaluator/GetResult/Compile {"Start":"2018-08-11T11:59:38.6420504Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"c2cb713e-57fb-45aa-b3b9-32d184883644","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:01.8971521"}
SimpleDocumentEvaluator/GetResult/Evaluate {"Start":"2018-08-11T11:59:40.5392597Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"c2cb713e-57fb-45aa-b3b9-32d184883644","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:01.0262774"}
SimpleDocumentEvaluator/GetResult<IPreviewValueSource> {"Start":"2018-08-11T11:59:38.6340159Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"c2cb713e-57fb-45aa-b3b9-32d184883644","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:04.1222913"}
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-11T11:59:38.2880453Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"c2cb713e-57fb-45aa-b3b9-32d184883644","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:03.2836027"}
SimpleDocumentEvaluator/GetResult/Compile {"Start":"2018-08-11T11:59:45.0907082Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"9d3becab-0c6d-4c39-9419-5bb1055a0e61","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:00.0342524"}
SimpleDocumentEvaluator/GetResult/Evaluate {"Start":"2018-08-11T11:59:45.1250154Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"9d3becab-0c6d-4c39-9419-5bb1055a0e61","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:09.2417431"}
SimpleDocumentEvaluator/GetResult<IPreviewValueSource> {"Start":"2018-08-11T11:59:45.0906444Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"720","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataFormat.Error] The input couldn't be recognized as a valid Excel document.\r\nStackTrace:\n at Microsoft.Mashup.Evaluator.Interface.EvaluationResult2`1.get_Result()\r\n at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass2.<BeginGetResult>b__0(EvaluationResult2`1 result)\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.Security.Cryptography.CryptographicException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Access is denied.\r\n\r\nStackTrace:\n at System.Security.Cryptography.ProtectedData.Protect(Byte[] userData, Byte[] optionalEntropy, DataProtectionScope scope)\r\n at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.CreateEncryptionKey()\r\n at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.GetEncryptionKey()\r\n at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.TakeHMac()\r\n at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.EncryptCacheKey(String cacheKey)\r\n at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.Services.WriteBehindPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.Services.TracingPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.DelegatingPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.Services.MinVersionPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.Services.KeyHashingPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.DelegatingPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.Services.ClearablePersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.Engine1.Library.PersistentCacheExtensions.TryGetStorage(IPersistentCache cache, String key, IStorage& storage)\r\n at Microsoft.Mashup.Engine1.Library.PersistentCacheExtensions.TryGetValue(IPersistentCache cache, String key, Stream& stream)\r\n at Microsoft.Mashup.Engine1.Library.Excel.SeekableBinaryValue.Open()\r\n at Microsoft.Mashup.Engine1.Library.Excel.ExcelReaderOpenXml.ReadTablesUnguarded()\r\n at Microsoft.Mashup.Engine1.Library.Excel.ExcelReaderOpenXml.ReadTables()\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"9d3becab-0c6d-4c39-9419-5bb1055a0e61","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:10.5360346"}
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-11T11:59:45.0892379Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"9d3becab-0c6d-4c39-9419-5bb1055a0e61","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:10.5376694"}

 

Log 3 when tried to save 

 

ObjectCacheSessions/CacheStats/Size {"Start":"2018-08-11T12:16:44.7417213Z","Action":"ObjectCacheSessions/CacheStats/Size","entryCount":"1","totalSize":"24","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":180,"Tid":15,"Duration":"00:00:00.0018480"}
ObjectCacheSessions/CacheStats/Access {"Start":"2018-08-11T12:16:44.7450868Z","Action":"ObjectCacheSessions/CacheStats/Access","hits":"0","requests":"1","hitrate":"0","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":180,"Tid":15,"Duration":"00:00:00.0001106"}

Status: Needs Info
See more ideas labeled with:
7 Comments (7 New)
Comments
Anonymous
Not applicable
‎08-11-2018 05:22 AM

I uninstalled previous version, removed Power Bi folder from Users directory and Installed August 2018 update. 

I can`t open pbix files, I cant enter data directly into pbix file or source it from excel. I can`t save PBIX files either. Here is a couple of logs

 

Log 1 when tried to open a pbix file

 

bjectCacheSessions/CacheStats/Size {"Start":"2018-08-11T11:47:36.4967412Z","Action":"ObjectCacheSessions/CacheStats/Size","entryCount":"1","totalSize":"24","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":720,"Tid":14,"Duration":"00:00:00.0049620"}
ObjectCacheSessions/CacheStats/Access {"Start":"2018-08-11T11:47:36.5063807Z","Action":"ObjectCacheSessions/CacheStats/Access","hits":"0","requests":"1","hitrate":"0","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":720,"Tid":14,"Duration":"00:00:00.0001016"}
RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-11T11:59:33.3172312Z","Action":"RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"720","identity":null,"evaluationID":"1","containerID":"1","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"c2cb713e-57fb-45aa-b3b9-32d184883644","Process":"PBIDesktop","Pid":720,"Tid":18,"Duration":"00:00:09.4303279"}
DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-11T11:59:33.1956961Z","Action":"DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"c2cb713e-57fb-45aa-b3b9-32d184883644","Process":"PBIDesktop","Pid":720,"Tid":18,"Duration":"00:00:05.0865256"}
RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-11T11:59:45.0693246Z","Action":"RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"720","identity":null,"evaluationID":"2","containerID":"1","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"9d3becab-0c6d-4c39-9419-5bb1055a0e61","Process":"PBIDesktop","Pid":720,"Tid":18,"Duration":"00:00:11.1053277"}
DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-11T11:59:45.0683572Z","Action":"DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"9d3becab-0c6d-4c39-9419-5bb1055a0e61","Process":"PBIDesktop","Pid":720,"Tid":18,"Duration":"00:00:00.0156653"}

 

Log 2 when tried to open excel file

ObjectCacheSessions/CacheStats/Size {"Start":"2018-08-11T11:59:37.8485160Z","Action":"ObjectCacheSessions/CacheStats/Size","entryCount":"1","totalSize":"24","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:00.0110290"}
ObjectCacheSessions/CacheStats/Access {"Start":"2018-08-11T11:59:37.9079357Z","Action":"ObjectCacheSessions/CacheStats/Access","hits":"0","requests":"1","hitrate":"0","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:00.0000917"}
SimpleDocumentEvaluator/GetResult/Compile {"Start":"2018-08-11T11:59:38.6420504Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"c2cb713e-57fb-45aa-b3b9-32d184883644","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:01.8971521"}
SimpleDocumentEvaluator/GetResult/Evaluate {"Start":"2018-08-11T11:59:40.5392597Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"c2cb713e-57fb-45aa-b3b9-32d184883644","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:01.0262774"}
SimpleDocumentEvaluator/GetResult<IPreviewValueSource> {"Start":"2018-08-11T11:59:38.6340159Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"c2cb713e-57fb-45aa-b3b9-32d184883644","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:04.1222913"}
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-11T11:59:38.2880453Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"c2cb713e-57fb-45aa-b3b9-32d184883644","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:03.2836027"}
SimpleDocumentEvaluator/GetResult/Compile {"Start":"2018-08-11T11:59:45.0907082Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"9d3becab-0c6d-4c39-9419-5bb1055a0e61","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:00.0342524"}
SimpleDocumentEvaluator/GetResult/Evaluate {"Start":"2018-08-11T11:59:45.1250154Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"9d3becab-0c6d-4c39-9419-5bb1055a0e61","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:09.2417431"}
SimpleDocumentEvaluator/GetResult<IPreviewValueSource> {"Start":"2018-08-11T11:59:45.0906444Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"720","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataFormat.Error] The input couldn't be recognized as a valid Excel document.\r\nStackTrace:\n at Microsoft.Mashup.Evaluator.Interface.EvaluationResult2`1.get_Result()\r\n at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass2.<BeginGetResult>b__0(EvaluationResult2`1 result)\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.Security.Cryptography.CryptographicException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Access is denied.\r\n\r\nStackTrace:\n at System.Security.Cryptography.ProtectedData.Protect(Byte[] userData, Byte[] optionalEntropy, DataProtectionScope scope)\r\n at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.CreateEncryptionKey()\r\n at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.GetEncryptionKey()\r\n at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.TakeHMac()\r\n at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.EncryptCacheKey(String cacheKey)\r\n at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.Services.WriteBehindPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.Services.TracingPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.DelegatingPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.Services.MinVersionPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.Services.KeyHashingPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.DelegatingPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.Services.ClearablePersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.Engine1.Library.PersistentCacheExtensions.TryGetStorage(IPersistentCache cache, String key, IStorage& storage)\r\n at Microsoft.Mashup.Engine1.Library.PersistentCacheExtensions.TryGetValue(IPersistentCache cache, String key, Stream& stream)\r\n at Microsoft.Mashup.Engine1.Library.Excel.SeekableBinaryValue.Open()\r\n at Microsoft.Mashup.Engine1.Library.Excel.ExcelReaderOpenXml.ReadTablesUnguarded()\r\n at Microsoft.Mashup.Engine1.Library.Excel.ExcelReaderOpenXml.ReadTables()\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"9d3becab-0c6d-4c39-9419-5bb1055a0e61","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:10.5360346"}
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-11T11:59:45.0892379Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"720","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"9d3becab-0c6d-4c39-9419-5bb1055a0e61","Process":"Microsoft.Mashup.Container.NetFX45","Pid":8624,"Tid":1,"Duration":"00:00:10.5376694"}

 

Log 3 when tried to save 

 

ObjectCacheSessions/CacheStats/Size {"Start":"2018-08-11T12:16:44.7417213Z","Action":"ObjectCacheSessions/CacheStats/Size","entryCount":"1","totalSize":"24","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":180,"Tid":15,"Duration":"00:00:00.0018480"}
ObjectCacheSessions/CacheStats/Access {"Start":"2018-08-11T12:16:44.7450868Z","Action":"ObjectCacheSessions/CacheStats/Access","hits":"0","requests":"1","hitrate":"0","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":180,"Tid":15,"Duration":"00:00:00.0001106"}

Seward12533
Solution Sage
Solution Sage
‎08-11-2018 05:46 AM
Not sure but you may want to post this on the issues forum vs desktop. I find this is more closely minutes my Dev team and I get faster response for bug reports.
Anonymous
Not applicable
‎08-11-2018 06:00 AM

thanks just did that as well

v-qiuyu-msft
Community Support
Community Support
‎08-14-2018 02:11 AM

Hi @Anonymous,

 

Please update your Power BI desktop to this version: 2.61.5192.601 then test again. If issue persists, please share desktop trace log around the time issue occurs with us. 

 

Best Regards,
Qiuyun Yu  

v-qiuyu-msft
Community Support
Community Support
‎08-14-2018 02:12 AM
Status changed to: Needs Info
 
Anonymous
Not applicable
‎08-15-2018 04:00 AM

Hi, @v-qiuyu-msft

 

Thanks for looking into that. I uninstalled the version i had and installed the last one you suggested. Nothing has changed unfortunately. 

What can else can i do to make it work?

 

HThat is when i tried to open a pbix file:

ObjectCacheSessions/CacheStats/Size {"Start":"2018-08-15T10:31:10.3638392Z","Action":"ObjectCacheSessions/CacheStats/Size","entryCount":"1","totalSize":"24","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":9336,"Tid":9,"Duration":"00:00:00.0034472"}
ObjectCacheSessions/CacheStats/Access {"Start":"2018-08-15T10:31:10.3728331Z","Action":"ObjectCacheSessions/CacheStats/Access","hits":"0","requests":"1","hitrate":"0","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":9336,"Tid":9,"Duration":"00:00:00.0000945"}
RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:19.4048320Z","Action":"RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","identity":null,"evaluationID":"3","containerID":"3","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"PBIDesktop","Pid":9336,"Tid":16,"Duration":"00:00:13.4621689"}
DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:19.4024992Z","Action":"DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"PBIDesktop","Pid":9336,"Tid":16,"Duration":"00:00:01.2234308"}
RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:16.4078147Z","Action":"RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","identity":null,"evaluationID":"2","containerID":"2","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"PBIDesktop","Pid":9336,"Tid":15,"Duration":"00:00:16.4562936"}
DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:16.4026523Z","Action":"DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"PBIDesktop","Pid":9336,"Tid":15,"Duration":"00:00:00.8618405"}
RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:13.4461515Z","Action":"RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","identity":null,"evaluationID":"1","containerID":"1","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"PBIDesktop","Pid":9336,"Tid":13,"Duration":"00:00:19.4015623"}
DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:13.4158293Z","Action":"DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"PBIDesktop","Pid":9336,"Tid":13,"Duration":"00:00:01.6709333"}
RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:32.9891513Z","Action":"RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","identity":null,"evaluationID":"4","containerID":"3","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"PBIDesktop","Pid":9336,"Tid":19,"Duration":"00:00:00.1669191"}
DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:32.9876101Z","Action":"DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"PBIDesktop","Pid":9336,"Tid":19,"Duration":"00:00:00.0485684"}
RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:33.1714162Z","Action":"RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","identity":null,"evaluationID":"7","containerID":"3","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"PBIDesktop","Pid":9336,"Tid":13,"Duration":"00:00:00.7732590"}
DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:33.1697739Z","Action":"DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"PBIDesktop","Pid":9336,"Tid":13,"Duration":"00:00:00.0077107"}
RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:33.1610815Z","Action":"RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","identity":null,"evaluationID":"5","containerID":"1","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"PBIDesktop","Pid":9336,"Tid":16,"Duration":"00:00:00.8472671"}
DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:33.1607072Z","Action":"DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"PBIDesktop","Pid":9336,"Tid":16,"Duration":"00:00:00.0356717"}
RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:33.1666168Z","Action":"RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","identity":null,"evaluationID":"6","containerID":"2","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"PBIDesktop","Pid":9336,"Tid":15,"Duration":"00:00:01.2121683"}
DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:33.1649716Z","Action":"DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"PBIDesktop","Pid":9336,"Tid":15,"Duration":"00:00:00.0463424"}
RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:33.9618260Z","Action":"RemoteDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","identity":null,"evaluationID":"8","containerID":"3","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"PBIDesktop","Pid":9336,"Tid":19,"Duration":"00:00:00.6658419"}
DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:33.9542311Z","Action":"DocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"PBIDesktop","Pid":9336,"Tid":19,"Duration":"00:00:00.5702447"}

 

And this one when i tried to enter data directly:

SimpleDocumentEvaluator/GetResult/Compile {"Start":"2018-08-15T10:31:34.5234072Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"9336","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"Microsoft.Mashup.Container.NetFX45","Pid":10008,"Tid":1,"Duration":"00:00:00.0220296"}
SimpleDocumentEvaluator/GetResult/Evaluate {"Start":"2018-08-15T10:31:34.5461211Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"9336","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"Microsoft.Mashup.Container.NetFX45","Pid":10008,"Tid":1,"Duration":"00:00:00.0608881"}
SimpleDocumentEvaluator/GetResult<IPreviewValueSource> {"Start":"2018-08-15T10:31:34.5233476Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"9336","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataFormat.Error] The input couldn't be recognized as a valid Excel document.\r\nStackTrace:\n at Microsoft.Mashup.Evaluator.Interface.EvaluationResult2`1.get_Result()\r\n at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass2.<BeginGetResult>b__0(EvaluationResult2`1 result)\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.Security.Cryptography.CryptographicException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Access is denied.\r\n\r\nStackTrace:\n at System.Security.Cryptography.ProtectedData.Protect(Byte[] userData, Byte[] optionalEntropy, DataProtectionScope scope)\r\n at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.CreateEncryptionKey()\r\n at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.GetEncryptionKey()\r\n at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.TakeHMac()\r\n at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.EncryptCacheKey(String cacheKey)\r\n at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.Services.WriteBehindPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.Services.TracingPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.DelegatingPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.Services.MinVersionPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.Services.KeyHashingPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.DelegatingPersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.EngineHost.Services.ClearablePersistentCache.TryGetStorage(String key, DateTime maxStaleness, CacheVersion minVersion, IStorage& storage)\r\n at Microsoft.Mashup.Engine1.Library.PersistentCacheExtensions.TryGetStorage(IPersistentCache cache, String key, IStorage& storage)\r\n at Microsoft.Mashup.Engine1.Library.PersistentCacheExtensions.TryGetValue(IPersistentCache cache, String key, Stream& stream)\r\n at Microsoft.Mashup.Engine1.Library.Excel.SeekableBinaryValue.Open()\r\n at Microsoft.Mashup.Engine1.Library.Excel.ExcelReaderOpenXml.ReadTablesUnguarded()\r\n at Microsoft.Mashup.Engine1.Library.Excel.ExcelReaderOpenXml.ReadTables()\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"Microsoft.Mashup.Container.NetFX45","Pid":10008,"Tid":1,"Duration":"00:00:00.0925151"}
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-08-15T10:31:34.5177490Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"9336","ProductVersion":"2.61.5192.601 (18.08)","ActivityId":"30993ee9-8d4d-42b8-9f20-659c9de16cfa","Process":"Microsoft.Mashup.Container.NetFX45","Pid":10008,"Tid":1,"Duration":"00:00:00.0983321"}

 

 

Anonymous
Not applicable
‎08-15-2018 04:15 AM

 

open pbix file.pngdirect data entry.png

Idea Statuses