Hi I have the following issue:
I keep getting a message in Power BI Designer Preview that states:
The 'collections.Name' column does not exist in the rowset.
I have a MySQL DB connected to an Access DB and then I've created and saved a query within Access.
Then I'm bringig in this query into Power BI Designer. To note, I can see my 1 row of data in the Query view of Power BI Designer but my error appears when I goto report after it tries to load the data into the model
the MySQL Statement looks like this:
SELECT orders.TRUNKSHOWID,
orders.ID,
orders.DATEENTERED,
orders_products.NUMBER,
orders_products.SIZE,
orders_products.DESCRIPTION,
products_categories.NAME AS Cat1,
products_categories_1.NAME AS Cat2,
collections.NAME,
Releases.Name,
orders_products.PRICE,
orders_products.DISCOUNT,
orders_products.TYPE,
products.WHOLESALECOST,
orders.FIRSTNAME,
orders.LASTNAME,
orders.ADDRESS,
orders.ADDRESS2,
orders.CITY,
orders.STATE,
orders.ZIP,
orders.COUNTY,
orders.COUNTRY,
orders.PHONE,
orders.EMAIL,
orders.BILL_FIRSTNAME,
orders.BILL_LASTNAME,
orders.BILL_ADDRESS,
orders.BILL_ADDRESS2,
orders.BILL_CITY,
orders.BILL_STATE,
orders.BILL_ZIP,
orders.BILL_COUNTRY,
trunkshows.TRUNKKEEPERID
FROM trunkshows
INNER JOIN (Releases
INNER JOIN ((((products
INNER JOIN (orders_products
INNER JOIN orders ON orders_products.ORDERID = orders.ID) ON products.ID = orders_products.PRODUCTID)
INNER JOIN products_categories ON products.CATEGORYID = products_categories.ID)
INNER JOIN products_categories AS products_categories_1 ON products.CATEGORYID2 = products_categories_1.ID)
INNER JOIN collections ON products.COLLECTIONSID = collections.ID) ON Releases.ID = products.ReleasesID) ON trunkshows.ID = orders.TRUNKSHOWID
