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!

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!