Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 > 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

Need Help

5 Replies

  • rajulshah's avatar
    rajulshah
    Icon for Resident Rockstar rankResident Rockstar
    6 years ago

    Hello Anonymous,

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

    DirectQuery is not supported for Excel Datasource.

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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.

     

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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