Forum Discussion

e9801591's avatar
e9801591
Icon for Helper I rankHelper I
5 years ago
Solved

Sharepoint excel data only showing column headers and not data

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...
Need Help
  • e9801591's avatar
    e9801591
    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

e9801591's avatar
e9801591
Icon for Helper I rankHelper 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's avatar
v-xulin-mstf
Icon for Community Support rankCommunity 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!