I've really hit a wall with the below, hoping someone might have an idea.
I have 3 dynamic excel sheets that my power queries are successfully updating and refreshing in PowerBi. 1 sheet is stored in my employer's SharePoint (employer.sharepoint.com), the other two are stored in the company we contract to's (contractor.sharepoint.com). I have limited permission's on the contractor SharePoint, but I am able to connect to the SharePoint folder and successfully run power queries. My username and password are the same in both accounts, and they both have MFA but I have created permissions and signed in to both under "organizational" and "windows account".
However, I have to run in import mode because I have to filter so much to make sure we only get "today's" sheet. This data is how we keep track of our agents working from home and the work they're processing.
Now that I've published the dataset, I can't run automatic refreshes (i know this isn't supported in Import mode), but the error I'm getting when refreshing manually is that the credentials in the data, despite the credentials being validated in PowerBi Desktop.
I've stored the .pbx in a sharepoint folder on the emplo
You can consider configuring Incremental refresh for your reports which extends scheduled refresh operations by providing automated partition creation and management for dataset tables that frequently load new and updated data.