Hi, I've been trying to work on this for the past 2 dasy and still can't figure out how to fix it. Data source is an excel file in sharepoint that is regularly being updated. No problem in connecting and accessing the file but when i view it in PBI desktop i can only see the 1st three rows. The 1st 2 rows are just merged rows for the file title and the actual data column headers are on the 3rd row. In PBI, no data from row 4 down is displayed. Can anyone help me with this or maybe provide some ideas on what I can do to check? Thank you very much!

This has been resolved - excel version is old (xls). updating the file to the latest version of excel solved the problem. Thank you for all the help

Sharepoint excel data only showing column headers and not data

parry2k
Super User
5 years ago
e9801591 is there step in the PQ that is filtering any data?
- e9801591
  Helper I
  5 years ago
  parry2k no filters. so far only 3 applied steps. 1. Source 2. Navigation 3. Change Type
parry2k
Super User
5 years ago
e9801591 very hard to say, just talking a loud

- are you connected to the right location/file

- are you navigating to correct sheet
v-xulin-mstf
Community Support
5 years ago
Hi e9801591

Are you importing a csv file or an xlsx file
What is the output of the file in PQ?

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
- e9801591
  Helper I
  5 years ago
  Hi. xlsx file. I opened the file in sharepoint and saved it and upon refresh in PBI i can now see the data. Must be file permissions?
  - v-xulin-mstf
    Community Support
    5 years ago
    Hi e9801591,
    
    You can check the Manage Access in sharepoint.
    
    You can also check if the following setting caused your issue:
    
    Best Regards,
    
    Link
    
    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
e9801591
Helper I
4 years ago
This has been resolved - excel version is old (xls). updating the file to the latest version of excel solved the problem. Thank you for all the help