Error SQLQuery to table not the same data.

[jpsolares]

Hi,

I just make a T-SQL Query

#invoice, DateInvoice, Month, year, Isoweek

When i see it in Power(In a table) its show different.

#InvoiceNumber, Isoweek, Month, Date

The problem that month and isoweek differ baddly.

Any idea to fix this thanks in advance.

Greetings,

JP

[v-haibl-msft]

@jpsolares

Please refresh the data first in Power BI Desktop and check the drop down menu of table fields as below.

I tried on Apr 2017 version of PBI Desktop and cannot repro the same issue on my side.

Best Regards,
Herbert