Before data can be loaded into Power BI, they have been transformed and modified with Excel’s Power Query. I have two sets of data. After transforming them, they have the same structure and same colu...
I cannot follow you. Why should Power Query using a mapping table if you didn't tell to do so? Could you post the M-code, some files or screenshot to understand what your queries are about and where the exact error is?
