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

parry2k's avatar
parry2k
Super User
5 years ago

bobli having said that I wouldn't recommend this method as it is not a scalable method if you really going to change values or adding new data. These approaches are more of storing some config values etc but not for maintaining the data. In this case, I would recommend doing transformation on your data file (even it is a bad format but hope there is a pattern and you can transform with Power Query) or maintain data in an Excel file, easier to work with and let Power BI use this excel file. The advantage of storing in excel is, if you need to change data or need to add rows, you don't need to open Power BI, just update the Excel file and refresh Power BI to get the data.

 

Good luck whatever way you decided to go.

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡