Sharepoint excel data only showing column headers and not data

[e9801591]

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!

[e9801591 · Accepted solution]

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

[v-xulin-mstf]

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]

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]

Hi @e9801591

Is your issue solved?

If the issue has been solved, please adopt the solution to help others.

If you still have some question, please don't hesitate to let me known.‌‌

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!

[v-xulin-mstf]

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!

[parry2k]

@e9801591 very hard to say, just talking a loud

- are you connected to the right location/file

- are you navigating to correct sheet

[parry2k]

@e9801591 is there step in the PQ that is filtering any data?

[e9801591]

@parry2k no filters. so far only 3 applied steps. 1. Source 2. Navigation 3. Change Type