DATATABLE issue when adding data

[JorisT]

I attended a class yesterday for some hands on Power BI training. Out of the 14 attendees I was the only one having this issue.

Steps to reproduce:

1. Create a new Power BI report.

2. Select Modeling / New Table, and enter the following DAX:

3. Table = DATATABLE("a", integer, "b", integer, {{1,2}})

An error message appears: The tuple at index '1' from the table definition of the DATATABLE function does not have the expected number of columns.

I am running Power BI Desktop version: 2.78.5740.861 64-bit (februari 2020) on Windows 10 Pro, version 1909.

I did play around a bit with the regional settings before these problems started. I have tried removing and re-installing Power BI Desktop, but this error keeps coming back. I have also installed the Dutch language version, in wich the data separator character is ; but the problem remains. Any help much appreciated.

[v-chuncz-msft]

@JorisT 

That works fine for me. You may check the post below.

https://community.powerbi.com/t5/Desktop/DAX-sintax-quot-quot-rather-than-quot-quot-syntax-error/m-p...

[JorisT]

@v-chuncz-msft 

Thanks, that article says 

Control Panel > Regional > Additional setting 

change list separator from ";" to ","

My list separator was set to ",". I changed it to ";" and now Power BI renders the statement

Table = DATATABLE("a"; integer; "b"; integer; {{1;2}})

Changing it back to "," brings back the problem. 

For now I can work with it. Thanks for your help.