Skip to content

[Bug]: Formatted files break semantic model #23

@mathisdrn

Description

@mathisdrn

Version 1.6.3

Description

The current extension can't be used to format .tmdl files because it produces invalid .tmdl that breaks reports file.

Steps to Reproduce

  1. Open the file and format in VS Code
  2. Format the document with the extension set as the default formatter
  3. Open the Power BI report in Power BI Desktop.
  4. See an error

Example:

Unformatted:

table LocalDateTable_16e399be-f8f3-4bb0-a609-44951c46145c
	isHidden
	showAsVariationsOnly
	lineageTag: e9ef0ae7-f387-442a-ac32-74d42ddb005d

	column Date
		dataType: dateTime
		isHidden
		lineageTag: d981db6c-e3eb-4107-8a19-7302d3bbdb84
		dataCategory: PaddedDateTableDates
		summarizeBy: none
		isNameInferred
		sourceColumn: [Date]

		annotation SummarizationSetBy = User

	column Année = YEAR([Date])
		dataType: int64
		isHidden
		lineageTag: 66cc9dfd-ab01-4920-b7f4-b322e0f093ea
		dataCategory: Years
		summarizeBy: none

		annotation SummarizationSetBy = User

		annotation TemplateId = Year

	column NoMois = MONTH([Date])
		dataType: int64
		isHidden
		lineageTag: ea726f33-5592-4df1-9571-5295fb4c11b9
		dataCategory: MonthOfYear
		summarizeBy: none

		annotation SummarizationSetBy = User

		annotation TemplateId = MonthNumber

	column Mois = FORMAT([Date], "MMMM")
		dataType: string
		isHidden
		lineageTag: 728fc12c-d4c7-4105-becb-7df881f8068b
		dataCategory: Months
		summarizeBy: none
		sortByColumn: NoMois

		annotation SummarizationSetBy = User

		annotation TemplateId = Month

	column NoTrimestre = INT(([NoMois] + 2) / 3)
		dataType: int64
		isHidden
		lineageTag: 41d62bcd-6c7d-408f-a167-24291eebf2fe
		dataCategory: QuarterOfYear
		summarizeBy: none

		annotation SummarizationSetBy = User

		annotation TemplateId = QuarterNumber

	column Trimestre = "Trim " & [NoTrimestre]
		dataType: string
		isHidden
		lineageTag: 58b92e0e-705a-41ef-8e99-7ad550119d30
		dataCategory: Quarters
		summarizeBy: none
		sortByColumn: NoTrimestre

		annotation SummarizationSetBy = User

		annotation TemplateId = Quarter

	column Jour = DAY([Date])
		dataType: int64
		isHidden
		lineageTag: 4636eeb7-3f83-4577-aba6-aa92e5357163
		dataCategory: DayOfMonth
		summarizeBy: none

		annotation SummarizationSetBy = User

		annotation TemplateId = Day

	hierarchy 'Hiérarchie de dates'
		lineageTag: ea37095e-a9dd-4f5e-93c4-fdd16d3b0349

		level Année
			lineageTag: 1ba48d7d-736a-48e9-ba90-d29fdc519c3b
			column: Année

		level Trimestre
			lineageTag: 2bcf599e-8695-45d0-8240-74f53888620e
			column: Trimestre

		level Mois
			lineageTag: 1cf1eec1-2194-4d23-b5b4-7d42b5679957
			column: Mois

		level Jour
			lineageTag: 38587732-74a7-4543-a500-9ba4fb5bba7c
			column: Jour

		annotation TemplateId = DateHierarchy

	partition LocalDateTable_16e399be-f8f3-4bb0-a609-44951c46145c = calculated
		mode: import
		source = Calendar(Date(Year(MIN('FAIT_COCKPIT_ZEROGASPI_COMPENSATION_SYNTHESE'[Catalogue date fin])), 1, 1), Date(Year(MAX('FAIT_COCKPIT_ZEROGASPI_COMPENSATION_SYNTHESE'[Catalogue date fin])), 12, 31))

	annotation __PBI_LocalDateTable = true

Format to (use compare with to see multiple errors and even removed content):

table LocalDateTable_16e399be-f8f3-4bb0-a609-44951c46145c
	isHidden
	showAsVariationsOnly
	lineageTag: e9ef0ae7-f387-442a-ac32-74d42ddb005d

	column Date
		dataType: dateTime
		isHidden
		lineageTag: d981db6c-e3eb-4107-8a19-7302d3bbdb84
		dataCategory: PaddedDateTableDates
		summarizeBy: none
		isNameInferred
		sourceColumn: [Date]

		annotation SummarizationSetBy = User

	column Année = YEAR([Date])
		dataType: int64
		isHidden
		lineageTag: 66cc9dfd-ab01-4920-b7f4-b322e0f093ea
		dataCategory: Years
		summarizeBy: none

		annotation SummarizationSetBy = User

		annotation TemplateId = Year

	column NoMois = MONTH([Date])
		dataType: int64
		isHidden
		lineageTag: ea726f33-5592-4df1-9571-5295fb4c11b9
		dataCategory: MonthOfYear
		summarizeBy: none

		annotation SummarizationSetBy = User

		annotation TemplateId = MonthNumber

	column Mois = 
		dataType: string
		isHidden
		lineageTag: 728fc12c-d4c7-4105-becb-7df881f8068b
		dataCategory: Months
		summarizeBy: none
		sortByColumn: NoMois

		annotation SummarizationSetBy = 

		annotation TemplateId = 

	column NoTrimestre = tionSetBy = User
		dataType: int64
		isHidden
		lineageTag: 41d62bcd-6c7d-408f-a167-24291eebf2fe
		dataCategory: QuarterOfYear
		summarizeBy: none

		annotation SummarizationSetBy = 167-2

		annotation TemplateId = 

	column Trimestre = zationSetBy = User
		dataType: string
		isHidden
		lineageTag: 58b92e0e-705a-41ef-8e99-7ad550119d30
		dataCategory: Quarters
		summarizeBy: none
		sortByColumn: NoTrimestre

		annotation SummarizationSetBy = 

		annotation TemplateId = e

	column Jour = mmarization
		dataType: int64
		isHidden
		lineageTag: 4636eeb7-3f83-4577-aba6-aa92e5357163
		dataCategory: DayOfMonth
		summarizeBy: none

		annotation SummarizationSetBy = ba6-a

		annotation TemplateId = 

	hierarchy 'Hiérarchie de dates'
		lineageTag: ea37095e-a9dd-4f5e-93c4-fdd16d3b0349

		level Année
			lineageTag: 1ba48d7d-736a-48e9-ba90-d29fdc519c3b
			column: Année

		level Trimestre
			lineageTag: 2bcf599e-8695-45d0-8240-74f53888620e
			column: Trimestre

		level Mois
			lineageTag: 1cf1eec1-2194-4d23-b5b4-7d42b5679957
			column: Mois

		level Jour
			lineageTag: 38587732-74a7-4543-a500-9ba4fb5bba7c
			column: Jour

		annotation TemplateId = 

	partition LocalDateTable_16e399be-f8f3-4bb0-a609-44951c46145c = 
		mode: import
		source = nTemplateId = DateHierarchy

	annotation __PBI_LocalDateTable = f8f3-

Expected Behavior

What should happen?

Actual Behavior

What actually happened?

Additional Context

Add any other context about the problem here or screenshots.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions