Forum Discussion

namitsamal's avatar
namitsamal
Frequent Visitor
8 years ago
Solved

Blank dates in PowerBI report

Hi,

 

I am refreshing my report in PowerBI service via access to an underlying sharepoint data. The data set gets refreshed with the latest data but does not pull date fields. When the same report is opened in PowerBI desktop and refreshed the dates appear Ok.

 

Any solutions ?

Need Help
  • lndnbrg's avatar
    lndnbrg
    8 years ago
    Can you test if your date column has errors that will be saved as blanks during the Power BI service refresh?

    It may be a date conversion issue, because your Desktop uses a different locale than the service. You may try to do the date conversion with a specific locale. Check this: https://www.excelguru.ca/blog/2015/07/08/fix-date-errors/

    Maybe this leads you to a solution?

12 Replies

  • lndnbrg's avatar
    lndnbrg
    Icon for Resolver III rankResolver III
    8 years ago
    Do you both use the latest version of Power Bi Desktop and Data Gateway?

    If the version of the Data Gateway is somewhat older, it may behave differently than Desktop.

    - Andreas
    • namitsamal's avatar
      namitsamal
      Frequent Visitor
      8 years ago

      Yes, I use the latest versions. When I publish from desktop to service the dates appear. However on first refresh from service everything is updated apart from date columns.

      • lndnbrg's avatar
        lndnbrg
        Icon for Resolver III rankResolver III
        8 years ago
        Does it also happen if you just import the raw SharePoint data - with just the Source step in your Query without any type conversions. Just to avoid any date format related issues.