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...
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.
Hi Ash1,
Have you resolved your issue? Please mark the right reply as answer. If you have not, don't hesitate to ask.
Thanks,
Angelia
