Mynda, I've found a workaround. If I open up the Excel file that's on SharePoint, go to File > copy the path, then can connect to From Web inste...
Perhaps it's a security issue I need to settle with my organization? The screenshot below shows that I'm able to connect but there many objects and I'...
Thanks, Mynda, I can't believe I couldn't figure that out! Now that I'm able to login, I can only connect to the root level and can't drill down to th...
That did the trick, Mynda. Thank you!
Mynda, Thanks for the reply. They are blanks in the Power Query editor. I tried the CODE function and it returned #VALUE! but not sure why it's thr...
Mynda, here is some additional info, not sure if you've seen this. In addition to the above issue, I also get the Compatibility Warning when opening w...
Thanks, Mynda, I hadn't thought of that. It works! It'll suffice until I can resolve the issue.
Thanks for the reply Mynda, but unfortunately that didn't work. Usually, if the the file path has changed, the old one still remains and you just go i...
Thank you so much for the explanation, I've learned so much from this post. You Admins on this forum are incredible.
It worked, thank you! I see that after I selected the column from the right side list of columns and double clicked on it, a # symbol was added before...
Thanks, I'll give that try shortly. However, I have run into another error. I've decided I want to bring in some additional columns that were previous...
Thanks so much for your help, Catalin. You set me on the right path. To solve, I replaced ID# null values with a hyphen. I was previously mistaken say...