PBI Service Refresh

[Selwynster]

I have Published a report to the Service but cannot refresh it.

The report only links to a website.

I get the folloing error: 

Data source error:

Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.

Please assist

(Ps. The Data Source Credentials option is disabled)

[TomMartens]

Hey @Selwynster ,

this somestimes happens, when the tables of your data model are connecting to more than one data source. This sometimes happen when you forgot to remove unnecessary tables from your data model, or redirect the data sources. Sometimes a table also points to an Excel file, somewhere on your local network or your local machine.

Local files need a gateway, if you are using Sharepoint online I recommend to move your local files to a Sharepoint online library, using Sharepoint online you can overcome the need for a gateway.

Hopefully, this provides some ideas on how to tackle your challenge.

Regards,

Tom 

[Selwynster]

Thanks but my only connection is to a website.

Works fine on Desktop but not on Service

[TomMartens]

Hey @Selwynster , can you please provide a screenshot of the data sources in your local pbix file

What is the authentication method of your web source, e.g. Power BI Service does not support NTLM authentication with web data sources.

Regards,

Tom

[Selwynster]

[aj1973]

Hi @Selwynster 

Change privacy level to None

[Selwynster]

Still the same

[aj1973]

@Selwynster 

Can you share the web site? I am going to try iy on my end

[Selwynster]

https://www.dailyfx.com/sentiment-report

[aj1973 · Accepted solution]

Hi @Selwynster 

Just tested it it all working fine

Desktop

Service(Sign in)

Refresh ( Personal Gateway/ my desktop)

Try to recreate you report from scratch or Publish it into a new Workspace.