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.
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.