Forum Discussion
Importing Excel dataset into PBIX. Not sourcing data from Excel.
Hi, guys. This is kinda difficult to explain as it is probably simple. How do you import Excel dataset within the PBIX file and not sourcing data from a separate Excel file? If I Get Data...
v-alq-msft
Community Support
Community SupportHi, Anonymous
Here is my table in Excel file. You can make the table selected, right-click the table and choose 'copy'.
Then you may do 'Enter Data' and paste the table to create the target table in Power BI.
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think cut & paste to Create Table has size limitation. Large data cannot be directly pasted into Create Table from Excel?
- v-alq-msft
Hi, rajulshah
It is possible to achieve your requirement by M query. For detailed information, you can refer to the following link.
Best Regards
Allan