Forum Discussion

Ash1's avatar
Ash1
Frequent Visitor
9 years ago

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...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

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.

 

 

Ash1's avatar
Ash1
Frequent Visitor
9 years ago

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

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    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 ?

    • Ash1's avatar
      Ash1
      Frequent Visitor
      9 years ago

      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

      • vanessafvg's avatar
        vanessafvg
        Community Champion
        9 years ago

        are you getting the same issue if you run the query in sql?

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    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