Forum Discussion

TiagoKorynek's avatar
TiagoKorynek
Regular Visitor
9 years ago
Solved

Issue when importing from an Access Database - Calculated Fields / Columns

I have recently started using PowerBI as it looked quite exciting to use to visualise data from my Access Database. I have been using PowerBI desktop and going through the usual Get Data -> From Access Database and going to my file to import the data. However, I seem to be getting quite a few errors and columns which do not get imported correctly and I believe they are to do with being calculated columns. Am I not ticking / selecting certain options or are these columns not supported in PowerBI and do I have to find some sort of work around to get these calculated columns?

 

I can't seem to be able to view the erroneous entries as all that seems to appear are the loading dots at the top of the screen. Therefore the calculated columns is only a hunch as a lot of these are coming back as 0 or Error even though they are all values >0 in my database.

  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi TiagoKorynek,

     

    Based on test, calculated field works and I haven't faced your issue, below is the test file.

     

    >>>>TblTcDelIDDATESTNATAATA4DIGITATA2DIGITATALAST2ATASecondaryDELAY HRSDELAY MINSAOGDelayTotalMinsEvent TypeSeverity Index

    In addition, can you fix your column name? It is hard to understanding above text.

     

    Regard,

    Xiaoxin Sheng

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi TiagoKorynek,

     

    Based on test, I can import the calculate fields to power bi,these fields display the correct value.

     

    Can you provide detail contents or share some sample file to test?

     

    Regards,

    Xiaoxin Sheng

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi TiagoKorynek,

         

        >>How do I upload a database or table?

        You can share the sample data of table and the formula of calculated field.

         

        Regards,

        Xiaoxin Sheng