Loading data from MS Access to PowerBI

[Anonymous]

Hello Everybody,

I'm quite new to PowerBI and I'm trying to solve two issues I have with loading data from MS Access to PowerBI:

1. I have a table with sales per Customer /product / month in MS Access. After loading this data to PowerBI I've noticed that total sales per month presented by PowerBI differs from the one in MS Access table - not for all Customers / products, but for few random ones. What could be the reason?

2. Could anyone please tell me how to associate two or more MS Access tables in one PowerBI report, if the tables have the same number of columns and the same columns headings, but contain data from different time periods, different Customers etc. I cannot figure out what kind of association I should apply to get in Power BI a simple table with sales per year. After loading two Access tables I get two sets of fields to combine in the report and it makes me confused.

Thank You in advance for helping me 🙂

[collinq]

Hi @Anonymous ,

I will answer the second question first.  To combine two tables that have some of the same columns and some different ones the way to combine them into one is to use the append.  Since your are new to this, you might try to use the "append as new" so that you can compare the result table against your two initial tables.

As for the first question, there are a number of potential issues.  If the sales are differing only slightly, could the issue be rounding?  Are you looking at the same level of detail for the Access version and the Power BI version?  Is the total sales a single value or is it being calculated?  If it is being calculated do you have the exact same calculations in both systems?

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!