-2
I am trying to learn how to use power pivot in conjunction with power query for obtaining and modeling data in excel.
I was able to import the databases and include them in the excel data model, however, when trying to manage the relations or any other type of calculation within the power pivot, the error appears below.
Link to download the workbook and investigate:
I would like help to understand what causes this mistake and how I can avoid it.
BS: These relationships aren’t working as well. If you can help me with that, too, I would be grateful!