Hi everyone,
For several months I have been developing and maintaining a dashboard that is updated monthly. We've been undergoing some IT updates, so until now, the data files have been stored in a folder on my desktop, which is what is linked to Power BI. Each month, I receive the new data and put it into the folder, then refresh and republish to our workspace for viewers. We are now migrating to SharePoint Online, and I have been asked to move the data folder to an SPO site. This is not working and I cannot figure out why. My process has been to go into advanced editor and update the location from Folder.Files("location") to SharePoint.Files("location"). I've removed all query and fragment bits from the URL and have double checked with the site administrator that it isn't a permissions issue. We are able to link individual Excel files via SharePoint, but not folders. I am getting this error:
DataSource.Error: SharePoint: Request failed: The remote server returned an error: (400) Bad Request. (Bad Request)
Does anyone know where I might be going wrong? I'm self-taught with Power BI/Power Query so while I'm generally competent sometimes I just have gaps I'm not aware of. Hoping that's all this is so I can sort it out quickly. Thanks in advance!
