Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 t...
Need Help
  • alexei7's avatar
    alexei7
    8 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
alexei7
Icon for Continued Contributor rankContinued Contributor
8 years ago

No, that should work!

 

Are your extra rows still there?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      alexei7
      Icon for Continued Contributor rankContinued Contributor
      8 years ago

      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!

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        thanks for your help!