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
Oh ok, so maybe edit the query to limit the rows and use the Query Editor to remove the columns.
Can you revert the query back to what it was but just put a TOP 100 in the SELECT ?
No luck.
I tried selecting all the columns with the dateadd fileter to limit rows. I'm seeing same error
The key didn't match any rows in the table
are you getting the same issue if you run the query in sql?
No. Query runs fine on SQL Server.
