Forum Discussion

AlexandreCop's avatar
AlexandreCop
Frequent Visitor
3 years ago
Solved

Importing Excel spreadsheet from SharePoint Site - Some cells are replaced with blanks

Hi,   The only related post I found was this one: https://community.powerbi.com/t5/Service/Cell-value-quot-TBD-quot-being-imported-a-blank/m-p/219591   I am importing an Excel spreadsheet from a ...
Need Help
  • AlexandreCop's avatar
    AlexandreCop
    3 years ago

    Hi,

     

    Some progress! It appears that if I try to connect to the spreadsheet from the web interface (with Get Data / Files / SharePoint - Team Sites, I guess the problem mentioned above.

     

    I have tried again, from Power BI Desktop this time, using Get Data / Web and enter the direct link to the spreadsheet. The data is now as I expect it to be!

     

    I'm not sure why the behaviour is different, but here we are...

AlexandreCop's avatar
AlexandreCop
Frequent Visitor
3 years ago

Hi,

 

Some progress! It appears that if I try to connect to the spreadsheet from the web interface (with Get Data / Files / SharePoint - Team Sites, I guess the problem mentioned above.

 

I have tried again, from Power BI Desktop this time, using Get Data / Web and enter the direct link to the spreadsheet. The data is now as I expect it to be!

 

I'm not sure why the behaviour is different, but here we are...

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Interesting find.  Sadly the web connector is not the preferred option (as it locks you into a single file). But at least the issue ticket now can write itself easier...