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