Importing Excel dataset into PBIX. Not sourcing data from Excel.

[Anonymous]

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

[v-alq-msft]

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

[v-alq-msft]

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.

[Anonymous]

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.

https://community.powerbi.com/t5/Power-Query/Copying-data-into-a-new-table-ignoring-the-data-source/...

Best Regards

Allan

[rajulshah]

Hello @Anonymous,

I assume you mean something like DirectQuery but with Excel Datasource, right?

DirectQuery is not supported for Excel Datasource.