Forum Discussion
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.
- Anonymous9 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
- AnonymousNot 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
- TiagoKorynekRegular Visitor
How do I upload a database or table?
- AnonymousNot 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