Forum Discussion
Modify query after datasource is created
Hello Is there a way to modify the datasource from which data has been loaded to PowerBI? Initially when I have created a report, I used Import query option to retrieve all the records, with...
Hi Ash1
If you can get into the Query Editor try clicking this button
Hopefully it brings up the query window where you can replace your query with one that contains just the columns you need and perhaps a WHERE clause that restricts your rows to exactly what you need.
Thanks for the reply,
It allows me to update the qeury, but I'm running into issues when I'm trying to apply the changes
Error: The key didn't match any rows in the table
Details:
Key= Record
Table = Table
~Ashwin