The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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)
Solved! Go to 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.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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
Thanks but my only connection is to a website.
Works fine on Desktop but not on Service
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
Hi @Selwynster
Change privacy level to None
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Still the same
Can you share the web site? I am going to try iy on my end
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
78 | |
36 | |
35 | |
23 | |
16 |