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
Icon for Microsoft Employee rankMicrosoft 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
    Icon for Community Champion rankCommunity Champion
    9 years ago

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

    • Ash1's avatar
      Ash1
      Frequent Visitor
      9 years ago

      No. Query runs fine on SQL Server. 

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

        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