Can Power BI import Certain range of data in Excel workbook

[Newark2023]

Hi, 

I have a simple question.

I know we can import the whole Excel workbook to Power BI easily. But what if I want to import some data in Excel workbook to Power BI, for example ranges like

A1:B10

C20: E56

Can Power BI do that? if yes, how?

Thanks

[Data-estDog · Accepted solution]

Yes. 
Use the transform option after selecting your workbook. Take a look at the keep rows, remove rows options. And take a look at the choose columns remove columns options. You may not be able to have 2 dynamic ranges off the same sheet. But what you can do is copy the sheet (righ click on sheet, copy). Then apply one range of columns and rows to one sheet, and the range of rows and columns to the other. Make sure to rename the sheets (queries) to something that represents the ranges appropriately. 
If I answered your question, please mark my post as solution, Appreciate your Kudos 

[Idrissshatila]

Hello @Newark2023 ,

What you can do in Power bi is that you can pick what columns you want with "Choose columns" option and you can filter to certain records.

https://learn.microsoft.com/en-us/power-query/choose-remove-columns

https://learn.microsoft.com/en-us/power-query/filter-values

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡