Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 > Excel, the data stays within the Excel file and not as a part of the PBIX entirely. If I do Enter Data to Create Table, there there is 3000 data limitation that makes the process clumbsy.
Any thought on this?
Thanks.
y
Hi, @Anonymous
If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.
Best Regards
Allan
Hi, @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?
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
Hello @Anonymous,
I assume you mean something like DirectQuery but with Excel Datasource, right?
DirectQuery is not supported for Excel Datasource.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |