Failed to load Date type Column

[ewicaksono]

I have 2 tables containing Date type columns each: Transaction table and Date Dimension Table.

Both table has relationship on that date column.

When I check on PowerBI desktop everything seems fine including the relation and format. After uploading the pbix to web server also the tables behave as I expected. However after the data refreshing finished shortly after the publishing succeded, The relationship went chaos.

When I download the uploaded PBIX I cant find the value of date type column that becomes the foreign key. All the value of date type columns are empty.

Have anyone experienced the same issues as I do?

I humbly ask for the solution.

Thank you

My failed problem solving trials:

- Updated the PowerBI

- Reuploading the downloaded PBIX after manually refreshing the data

- Change data type to locale

[Anonymous]

@ewicaksono,

Do you also get empty values in Power BI Service report? Could you please share the PBIX file via Private message? I will test it in my Desktop.

Regards,
Lydia

[ewicaksono]

@Anonymous 

I am sorry but I can't share you the PBIX since it's confidential. But it happened to me twice. at first I thought it was happened because of the date type, when I rechecked on another dataset I found the same problem on string type. 

This string type column was modified through query. I split the string by fixed number.

The date type column also was modified through query. I changed the data type frome datetime to date.

I hope it can help you analyze the problem.

Much thanks.

[ewicaksono]

It turns out that the problem laid on the date time that is converted into date on query mode. There is still bug on the query data type alteration that cause the data failed to load. I remove the step to change data type and change the format on modelling instead. It worked