Forum Discussion

Kyointruder's avatar
Kyointruder
Frequent Visitor
3 years ago
Solved

Problems import DateTime excell to Power Bi

I'm having trouble importing a DateTime column from Excel to Power BI. In excel it is seen very well. But after it is imported into Power BI, all fields are seen as "null". even changing in Power Query the column to the data type "DateTime". how to solve?

Excell:

 

Power Bi - Power query:

 

 

  • Sanited? Follow my excel with the dates: 

    This Columm "Data Exibição" is load "null" in Power BI. This is my problem.

     

     

2 Replies

  • davehus's avatar
    davehus
    Memorable Member

    Hi Kyointruder ,

     

    Have you a sanitized version of your report that we could look at for you?

     

    Did I help you today? Please accept my solution and hit the Kudos button.

    • Kyointruder's avatar
      Kyointruder
      Frequent Visitor

      Sanited? Follow my excel with the dates: 

      This Columm "Data Exibição" is load "null" in Power BI. This is my problem.