Converting PBIX to PBIR

[Chythra]

Hello All,

I am checking the feasibility of converting a PBIX file to the latest PBIR format (not Legacy PBIR). As soon as I convert the file, I am getting the below error. Has anyone faced this issue? How to get around this? I have 22 such errors for 1 Report. 

One of the properties 'SourceRef,Column,Measure,Min,Max,Aggregation,Percentile,Hierarchy,HierarchyLevel,PropertyVariationSource,Subquery,Discretize,And,Between,In,Or,Comparison,Not,Contains,StartsWith,Exists,Literal,DateSpan,DateAdd,Now,DefaultValue,AnyValue,Arithmetic,Floor,ScopedEval,FilteredEval,TransformTableRef,TransformOutputRoleRef,SparklineData,NativeVisualCalculation,FillRule,GroupRef,ResourcePackageItem,RoleRef,SummaryValueRef,AllRolesRef,SelectRef,ThemeDataColor,Conditional,NativeMeasure,NativeColumn' must be provided in the /explorationState/sections/ReportSection0bb7c317910bc16deaf5/visualContainers/8e9b2d63cc452b8bb68a/singleVisual/projections/Rows/0 property of Bookmark6c5989e28a0c849aa4c3.bookmark.json.
Property /explorationState/sections/ReportSection0bb7c317910bc16deaf5/visualContainers/8e9b2d63cc452b8bb68a/singleVisual/projections/Rows/0 in Bookmark6c5989e28a0c849aa4c3.bookmark.json was not provided as the correct type.

[adetox]

Yes! I do have a very similar error. I convert the file to PBIR, save, and then I cannot open it back "Your report has issues that cannot be resolved". Luckily I was in git and could revert back but that work of that day is lost.

Here's a piece

• Property /explorationState/sections/ReportSection3b238290658704b14cb6/visualContainers/66036d835d06cbfa645a/filters/byExpr/0/name in Bookmark3f2ce945d81929a4ca78.bookmark.json was not provided as the correct type.
  
  So I went to the JSON and I find this piece of code

"66036d835d06cbfa645a": {
            "filters": {
              "byExpr": [
                {
                  "name": null,
          ​

This "null" in the name seems the offender

[Anonymous]

Hi @Chythra ,

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[katty867]

Hello,

MyCenturaHealth

Enable Preview Features: Ensure that the “Store reports using enhanced metadata format (PBIR)” feature is enabled in Power BI Desktop. You can do this by navigating to File > Options and settings > Options > Preview features and checking the relevant box.
Check JSON Schema: Verify that all required properties are correctly defined in your JSON files. The error message you provided indicates that certain properties are either missing or not of the correct type. You can refer to the PBIR JSON schema documentation for detailed information on the required properties.
Manual Correction: If the error persists, you might need to manually edit the JSON files. This involves ensuring that all properties listed in the error message are correctly defined and typed. Be cautious with this approach, as incorrect changes can cause further issues.
Backup and Retry: Before making any changes, create a backup of your PBIX files. This way, you can revert to the original state if needed. After backing up, try converting the file again and see if the issue persists.

Best Regards

katty867