Forum Discussion
Expression Error: Column not found in table
Unfortunately that does not work, still receive the same error message.
Also, if I remove both steps (Renamed Columns Changed Type) and leave only 'Source' all my columns disappear and I get 235 rows of table information (Catalog, Description, Item etc.), one row for each table in my source DB (MySQL).
I would like PowerBI to make asbolutely no changes to my data model actually.
I have no experience with connecting to Power Pivot, but I know you can import Excel workbooks into Power BI.
Or search for information available, e.g. in this topic.
It looks like the subject ("Expression Error: Column not found in table") doesn't cover what you actually want to achieve, so if you can't find sufficient information, then my advice would be to raise a new topic with a title like "How to copy Power Pivot to Power BI?" or something similar.