cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sjensen Regular Visitor
Regular Visitor

Changing data from the sheet to the Table

I show on my Data tab that it is blank so I scroll down and see that the data is way down below. I then go to the edit query and see that for some reason it is pulling the sheet data instead of the table data. How do I change the data pull to the table not the sheet?

 

1 ACCEPTED SOLUTION

Accepted Solutions
alexei7 Established Member
Established Member

Re: Changing data from the sheet to the Table

Yes, i think because Power BI has to navigate to the table from the sheet, so it always looks at sheet to start with.

 

Glad i could help!

View solution in original post

6 REPLIES 6
alexei7 Established Member
Established Member

Re: Changing data from the sheet to the Table

Hi @sjensen,

 

If you go into edit edit query, you should click on "Source" in "Applied Steps" on the right hand side of the screen.

Applied Steps.PNG

 

From here the main screen should show you something like the below. You should click on the "Table" link next to "Table1" (or whatever your table is called".

Power BI will probably prompt that you are creating a new navigation step; click "Continue".

 

 

Table.PNG

 

Hope that helps,

Alex

sjensen Regular Visitor
Regular Visitor

Re: Changing data from the sheet to the Table

Thank you for the information. So I click on the table under data and it says 

 

"Navigation Step

You are about to create a navigation step that replaces the subsequent steps. Do you want to continue?"

 

I click continue and it jumps to Changed type but nothing changed? Am I missing a step?

alexei7 Established Member
Established Member

Re: Changing data from the sheet to the Table

No, that should work!

 

Are your extra rows still there?

sjensen Regular Visitor
Regular Visitor

Re: Changing data from the sheet to the Table

No they are not that fixed it for sure. If it is good staying as a sheet that I am good with that. I was just thinking it was going to change it from a sheet to table but this still works. 

alexei7 Established Member
Established Member

Re: Changing data from the sheet to the Table

Yes, i think because Power BI has to navigate to the table from the sheet, so it always looks at sheet to start with.

 

Glad i could help!

View solution in original post

Highlighted
sjensen Regular Visitor
Regular Visitor

Re: Changing data from the sheet to the Table

thanks for your help!

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors