I'll start by saying that I'm totally new with PowerBI, so I apologize if the answer has already been posted, I couldn't find it.
So here it is :
My data source is a database with multiple tables and views. Here I wanna work only with my views, and I can't alter this database.
I have a view A where I only need 1 column that'll give me a list of names (A, B, C, ...). Column colNAME1.
I have a view B that can show rows only if I have at least a WHERE clause with one of these names selected.
view B is like ColNAME2, ColValue, ColDateTime
multiple rows will have colName2 since it has a lot of values
So It's like :
SELECT * FROM dbo.MyViewB WHERE colNAME2= '(value from colNAME1)'
Now I want to translate it in Power BI.
So I've added a Slicer, with my names data on it. I've configured it as a dropdownlist where I can select only 1 name.
I've added a table connected to my second view.
But I don't know how to link them... I though it'd be automatic since when I am on my table, the filter button on top shows that the name selected in the slicer is applied, but I still get an error and no data are shown.