Forum Discussion

mkeeping's avatar
mkeeping
Regular Visitor
6 years ago

Dates import as Null while Querying from Sharepoint folder

I have an xlsx file in a Sharepoint folder and I create a query to import it to Power Bi. It has several date columns but they all show up as having null as the value. If I open the file the dates are there. If I download the file from Sharepoint and import  excel file the dates show up correctly. I get two different behavours when importing the same excel file into PowerBI. Is anyone else able to reproduce this?

Need Help

9 Replies

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi mkeeping,

    If possible, could you please inform me how you connect to sharepoint folder? When you connect to sharepoint folder , you need to use URL like below

     

    https://<your company>.sharepoint.com/teams/<your site>

     

    Or you also could try to connect to it by web like below

     

    https://<your company>.sharepoint.com/teams/<your site>/Shared%20Documents/Book3.xlsx

     

     

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • mkeeping's avatar
      mkeeping
      Regular Visitor
      6 years ago

      I connect to the folder then do a transform in order to navigate to the specific table.

       

      https://<your company>.sharepoint.com/teams/<your site>

       

      • dax's avatar
        dax
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi mkeeping,

        So may I know how is your issue going currently? If your issue is solved please mark the appropriate answer as Mark as answer. This will help other members to find a solution if they face the same issue. If you still have any questions, please feel free to ask.

        Thanks for your understanding and support.
        Best Regards,
        Zoe Zhi

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    5 years ago

    Hello good day, I have the same problem. When you want to upload an excel file that contains dates, PBI detects them as null, I already tried changing the format from excel and it still does not detecarlas. how can I get PBI to read the dates?

    Fotoexcel.JPGFotopbi.JPG

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    3 years ago

    Good! Did you solve the problem? The same thing just happened to me and I think it's not a problem of the file being in Sharepoint or a local folder. In my case the problem was that the excel format, although it was xlsx, the file type was "Strict OpenXML spreadsheet (*.xlsx)". As soon as I changed it to "Excel workbook (*.xlsx)" it has already recognized the dates without any problem.