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...
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
Hi Ash1,
You click the button as Phil_Seamark posted, you will get the Navigator like the following screenshot.
You use the same SQL Statement in highlighted line area as in SQL Server, it return the error message? It's weird. Please close the Edit Query and open it, and check if it works fine.
Thanks,
Angelia