Access to source forbidden when trying to refresh data
I have a dashboard that has around 10 tables all linked to sources from a shrepoint page and every time I want to refresh the dashboard I get a message (in turn for each table as I work through them) which says "Access to the source is forbidden".
To get around this I have to go into the data source settings, select each table and Edit credentials (It tells me I'm already signed in) but I am forced to sign in with another user and then sign myself in again. When I have done this once it seems to run ok for any subsequent refreshes done before I exit the file, but the next day it happens all over again.
Has anyone had any experience with this or know if there is a way to stop me having to sign back into the source every single time? as there are so many table sources its time consuming repeating this every day.
I wonder if you are using OneDrive or OneDrive for Business. When you connect to OneDrive for Business in Power BI, connection is easy because your Power BI account is often the same account as your OneDrive for Business account. With personal OneDrive, you usually sign in with a different Microsoft account. When you sign in with your Microsoft account, be sure to select Keep me signed in. Power BI can then synchronize any updates you make in the file in Power BI Desktop with datasets in Power BI.
Things may also go wrong if the dataset tries to connect to an on-premises data source but the gateway is offline. To avoid these issues, make sure Power BI can sign into data sources. Try signing into your data sources in Data Source Credentials.
When you save your changes to the Power BI Desktop file on OneDrive and you don't see those changes in Power BI within an hour or so, it could be because Power BI can't connect to your OneDrive. Try connecting to the file on OneDrive again. If you’re prompted to sign in, make sure you select Keep me signed in.
For further information, please refer to the following links.
Thanks for your response, I am using SharePoint not Onedrive does this make any difference?
The connection seems to be fine between the two when I re-enter mycredentials it refreshes no problem, it's just the fact I am having to re-enter me credentials 10 times to get each table to refresh every time I reopen the file even though the credentials are stored and still signed in.