Assistance with SQL Parameters in Power BI - Help with creating a list from SQL Query
Sorry, repeating as my first question was marked as spam. I removed the link which I assume is why my post was removed.
I have been trying to follow this link to create a list in Power BI. For a little background, I am attempting to create a dataset within Power BI that has products, their list price, quantities sold, etc. But I would like to filter this by category and eventually by subcategory using AdventureWorks2014 Database. It was incredibly difficult to figure out a way to do this with step by step guides. (Are there any clear resources that discuss this?...I came across some questions on this forums and the answers pointed to a blog that wasn't of much help). I finally came across this link that provided me a little clarity. I have to create a list, I can't simply simply do a normal SQL query like the one I was sttempting to do, because when I select for Query when creating a parameter, the list does not show up. Below is my code, where AventureWorks2014 is the database, Production is the schema,
ProductCategory is the table and "Name" is the field I want to create a list from.
Update: I updated my source by clicking on the exact table I was referencing and my code has been changed to correctly reflect the dbo and table. New code below:
Thank you. I didn’t understand what the parameters for the Table.AddColumn functions were and I was trying to use an example I saw online as a template. Where I wrote “Name”, I was expected to put a function. That’s why I was getting a type error. each [Name] was the function I needed to fill the column.