Forum Discussion
How to create many identical reports/visuals with different data sets?
Hi, Anonymous
When you meet the error “The key didn’t match any rows in the table”. It means that the names, numbers of columns in the table from your data source have changed. You should check it first. Then you can go to the Power query editor->advanced editor to change the column name to exactly match your data source table, like this:
To switch the dataset manually through the parameter, you can try DavidBI’s suggestion which is mentioned above. Or you can just simply change the data source in Power query editor.
If this result is not what you want, you can post some sample files(without sensitive data).
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Solution SpecialistHi, Anonymous ,
You can put your Excel data source in different folders under the same path, and then you can create a parameter in PowerQuery to dynamically control the path of the data source. Then you need to save the file as PBIT format. So when you need to create a new report, you only need to input the corresponding parameter value.
About Query Parameter in PBIT, you can refer to this blog post by Miguel
Mark this post as solution if this helps, thanks!