Forum Discussion

bobli's avatar
bobli
Frequent Visitor
5 years ago
Solved

Query result to embed table

Hello, Is there a way to embed the query result directly to powerbi report so that I can remove the dependence on the external file? The ideal case would be the "Enter Data" but the data is a litt...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi bobli ,

     

    You could use Import mode to load data first, then copy the table and paste the table in enter data feature.

     

    Best Regards,

    Jay

  • bobli's avatar
    bobli
    Frequent Visitor
    5 years ago

    Thanks for the advice. Is there any reference to pass the query result into the Table or DataTable function?

    • PhilipTreacy's avatar
      PhilipTreacy
      Super User
      5 years ago

      Hi bobli 

      Sorry I don't know any way to explicitly do that.  Once the data is loaded into PQ it is automatically loaded into the Data Model on Close & Apply.

      Regards

      Phil