Forum Discussion

akemr's avatar
akemr
Icon for Helper II rankHelper II
6 years ago

Single Row of Data from Source Teams Excel File doesn't show up in the Local PBID Dataset

Hi all,   Would appreciate any help.    So my source file is on a Teams folder. I opened the folder in Sharepoint and used the Sharepoint connector to access the folder and then the file, and eve...
Need Help
tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
6 years ago

Sounds like there is something wrong in the excel file. Try copying the entire table and paste values to another page in the excel file to see if there is any issues related to the formatting. 

You should also check if the row is present in power query, I don't know if you are doing any transformations there that could affect the outcome of the load. 

Br,
J