Forum Discussion
Selecting from database with dynamic filter from table
Maybe there is some help and maybe it is not possible, but i do have a question. I have a simple Excel table with some numbers in it (projectnumbers) ID Projectnumber 1 2345 2 5642 ...
Thanks for your answer.
The solution offerd is a solution in Excel. Making the sql statement in Excel works if you are a single user or the owner of the excel file. In my case the projectteam is owner of the Excel file and not willing me to put in code. So every update will be an Excel file without code. (and its automated so i dont see if a new version is published)
Maybe I should use a dataflow to prepare the data. he effect will be the same, a thin and swift report.
The solution offered is a powerbi solution.
All the steps take place in Power Query in Powerbi. You will have 2 queries there : the Excel query and the SQL query.