Hello all, I have been having an issue in PowerBI Service where I am unable to set up a scheduled refresh.
The .pbix file is stored on SharePoint and data source is Azure blob store, where I used Org Auth credentials in the data source permissions to fetch data. It works perfectly fine on the PowerBI desktop but when I publish it to a workspace, and try to set up a scheduled refresh, it says - Failed to update data source credentials: The credentials provided for the AzureBlobs source are invalid.
I used the same org auth credentials (as in the PowerBI desktop in the data source settings) yet for some reason, it does not pick up and recognize the data source credentials. I even tried using a SAS token approach - first modified the permissions on the desktop version, published it and used the same SAS token on the web-version, yet the same error message.
Clearing cache, deleting the files on workspace and republishing did not help either. Apologies if this question was already posted and answered, I checked the forums and found some solutions but none of them seem to work in my case. Any help would be highly appreciated.
Thanks,
MM