cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

ERROR: Required property 'Connections; not found

On opening various different files in Power BI I run into this error: 

 

Something went wrong

Required property 'Connections' not found in JSON. Path ", line 1, position 136.

Copy details

 

Then Power BI closes. 

 

Has anyone else experienced this?

 

I've tried downloading the file from Power BI service and I run into the same problem. Here are the copied details: 

 

Feedback Type:
Frown (Error)

Error Message:
Required property 'Connections' not found in JSON. Path '', line 1, position 136.

Stack Trace:
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.EndProcessProperty(Object newObject, JsonReader reader, JsonObjectContract contract, Int32 initialDepth, JsonProperty property, PropertyPresence presence, Boolean setDefaultValue)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.PopulateObject(Object newObject, JsonReader reader, JsonObjectContract contract, JsonProperty member, String id)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)
at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)
at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)
at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings)
at Microsoft.PowerBI.Client.Windows.Services.ReportFactory.DeserializeJsonObject[T](String jsonContent)
at Microsoft.PowerBI.Client.Windows.Services.ReportFactory.DeserializeJson(Byte[] data)
at Microsoft.PowerBI.Client.Windows.Services.ReportFactory.CreateReportFromPowerBIPackage(IPowerBIPackage powerBIPackage, String pbixFilePath, Byte[] securityBindings, Boolean requiresConversionToReportLayout, PowerBIPackageOpenOptions options, IPowerBITelemetryService powerBITelemetryService, IAnalysisServicesService analysisServices, PackageValidationResult& mashupValidationResult)
at Microsoft.PowerBI.Client.Windows.Services.PowerBIPackagingService.Open(FileStream fileStream, IPowerBIWindowService windowService, Nullable`1 entryPoint, PowerBIPackageOpenOptions options, ReportPreparerResult& prepareResult)
at Microsoft.PowerBI.Client.Windows.Services.FileManager.<LoadFromPbix>d__20.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.<>c__DisplayClass15_0`1.<<BlockUIAndRun>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.WaitOnUIThreadForTaskCompletion(Task task)
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.BlockUIAndRun[T](Func`1 asyncMethod)
at Microsoft.PowerBI.Client.Windows.Services.FileManager.OpenFile(IPowerBIWindowService windowService, IPbixFile fileToOpen, Nullable`1 entryPoint)
at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IUIHost uiHost, ISplashScreen splashScreen, IFileManager fileManager, IFileHistoryManager fileHistoryManager, String filePath, FileType fileType)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Stack Trace Message:
Required property 'Connections' not found in JSON. Path '', line 1, position 136.

Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)

 

 

 

 

31 REPLIES 31
Highlighted
Frequent Visitor

I'm having this issue too and it just started in the middle of my day with pbix files that I was just working with earlier in the day.  I've been on the latest version of Power Bi desktop for weeks.  How can this issue suddenly pop up out of nowhere?  Not sure what to do as I don't even know what version I was using when I first created these files. Also I want to reiterate that I've been able to open/save and work with all these files for months right up to the middle of today. 

Highlighted

This happened to me today on one particular report.

Following @chenthorn 's suggestion, here's what I did to get it working:

 

1. Found a .pbix that would open as expected

2. Opened .pbix archive with 7-zip

3. Right-clicked [Content_Types].xml and selected Edit

4. Selected all text and copied

5. Repeated steps 1-3 on .pbix that wasn't working

6. Selected all text and pasted

7. Save and select to also save in archive if 7-zip prompts you for this

 

My .pbix now opens, refreshes, and publishes to service with no issues.

 

Best of luck!

Highlighted

I'm having the same issue with all my files suddenly.

 

tried every version of PowerBI

Highlighted

I found a simple/annoying workaround.  Open a blank BI Desktop and use the Open option in the file menu to open your pbix's.  Annoying but it works.

Highlighted

Thanks for tip.  Seems like alot of work though since I have dozens of dashboards that all have this problem.  I did find that using the open option under the file menu on a blank BI Desktop works though.

Highlighted

Sadly opening in a blank page isn't working for me. Any other solutions?

Thanks.

Highlighted
Regular Visitor

I had a similar issues today with several of my pbix files ("Required property 'Connections' not found in JSON. Path ", line 1, position 136."). I opened the pbix with 7z and deleted the Connections file inside the package. I was then able to open the file and connect to the data source.

Highlighted
Regular Visitor

how do you choose diffrent versions? or how do you download diffrent versions of BI?

Highlighted

Hi @malkha ,

 

If you're after the newest version of Power BI Desktop you can get it here:

 

https://powerbi.microsoft.com/en-us/downloads/

Highlighted

That's a really sneaky solution, I like it.

It worked for me too.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors