Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Only take data from excel file within area formatted as table

Hi all,   I am new to Power BI and I want to analyze data from an excel file. However, I only want to take those data from the excel file which are in an area formatted as a table. The reason is th...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    1. You need to save the file first and then the table can be read and recognized by PowerBI when it connects.

    2. Power BI is a reporting platform, and it is not good at writing back data.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Problem ihas been solved, principally Power BI can take data only from tables which are formatted as such. The problems are

1. Power BI seems to take some time to recognize new tables created in a file

2. Power BI does - in my case - not update data saved on SharePoint

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

1. You need to save the file first and then the table can be read and recognized by PowerBI when it connects.

2. Power BI is a reporting platform, and it is not good at writing back data.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data