Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Everything works fine in Power BI Desktop. However, in the Power BI service and report server, I encounter an error stating "The data source extension does not have any credentials and is not accessible". I tried to verify the credentials, which are the same as those used in Power BI Desktop, but they are being rejected by the Power BI service.
;
;
;
Use the following this should work.
1. Reconfigure Data Source Credentials:
• Go to the Power BI Service (app.powerbi.com).
• Navigate to the workspace where your report is published.
• Click on the Datasets tab.
• Find the dataset related to your report and click on the ellipsis (…) next to it.
• Select Settings.
• Under Data source credentials, click on Edit credentials.
• Provide the necessary authentication details and save.
2. Data Gateway Configuration:
• If your data source is on-premises, ensure that the On-premises Data Gateway is properly installed and configured.
• In the Power BI Service, go to the Manage Gateways section under the Settings menu.
• Check that the data gateway is online and properly mapped to your dataset.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.