Forum Discussion

Chris_D-'s avatar
Chris_D-
New Member
2 years ago
Solved

Sharepoint Source Refresh Issue after adding 2nd Sharepoint Directory

Hello! Was able to successfully create a report that used a single Excel file on Sharepoint.  Published it to the cloud and found it refreshed automatically without issue.  Needed to add a second Sh...
  • Chris_D-'s avatar
    Chris_D-
    2 years ago

    Hello Ibendlin!

     

    Your initial advice to "clean up the queries" was correct.  After trying different ways to define SOURCE and create credentials, it occurred to me to check the Sharepoint directories to confirm contents.  Turned out there were 2 files in the first directory. 

     

    Originally, I had uploaded the second file to the first Teams site.  Then decided to create a different Teams site with different security access so users could update the file themselves.  What I didn't know is that when I deleted the second file in the first Teams site, the delete did not carry through to Sharepoint.  That was quite a surprise - and an important thing to know for many reasons besides building reports.  After deleting the second file in first SharePoint folder, the PowerBI report worked.      

     

    Thanks your help!  

    Chris