'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix DMTS_DatasourceHasNoCredentialError for SAP HANA in Power BI Service
Question details
The user needs to resolve an authentication error that prevents an SAP HANA Datasphere ODBC connection from working in Power BI Service.
- Product
- Power BI Service, SAP HANA Datasphere
- Device & OS
- not provided
- Scenario
- Publishing a report using an SAP HANA Datasphere ODBC connection from Power BI Desktop to Power BI Service.
- Observed behavior
- The connection works successfully in Power BI Desktop but fails in Power BI Service, returning a DMTS_DatasourceHasNoCredentialError stating that the connection has no credentials.
Ensure you have workspace administrator or member permissions in Power BI Service, and verify that your SAP HANA Datasphere ODBC credentials are correct and accessible.
Configure Data Source Credentials in Power BI Service
Manually update the dataset settings in the cloud to provide the missing authentication details required by Power BI Service.
Power BI Desktop uses your local machine's ODBC DSN and local credentials. When published to Power BI Service, the cloud environment does not automatically inherit these credentials. You must explicitly configure the dataset's credentials to resolve the DMTS_DatasourceHasNoCredentialError.
Log in to Power BI Service, navigate to your Workspace, and locate the dataset that is failing to refresh.
Click the More options (...) icon next to the dataset name and select Settings.
Expand the 'Data source credentials' section. You will see a warning next to your ODBC connection. Click 'Edit credentials'.
Select the appropriate Authentication method (usually Basic) and enter your SAP HANA Datasphere username and password. Set the privacy level and click 'Sign in'.
Seek Specialized Assistance in the Power BI Community
Consult Microsoft guidance and community engineers for complex cloud connection issues.
Manage Your Data Reports and Troubleshooting Logs with WPS Office
While resolving complex Power BI and SAP HANA data connectivity issues, you need a reliable office suite to document errors, analyze raw data exports, and present your findings. WPS Office is a powerful, lightweight, and free alternative that meets all your daily productivity needs.
- 1. Download the Installer: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install the Software: Run the setup file and follow the quick installation prompts to set up WPS Office on your computer.
- 3. Open Your Office Files: Launch WPS Office to instantly view, edit, and save your existing Microsoft Office documents, spreadsheets, and presentations.
Frequently Asked Questions
Why does my SAP HANA ODBC connection work in Power BI Desktop but fail in Service?
Power BI Desktop utilizes your local machine's ODBC Data Source Name (DSN) and locally cached credentials. Power BI Service operates in the cloud and cannot access your local DSN or credentials automatically; they must be explicitly re-configured in the dataset settings in the cloud.
What does DMTS_DatasourceHasNoCredentialError mean?
This is a Microsoft Power BI error code indicating that the cloud service is attempting to connect to or refresh a dataset, but no valid authentication credentials have been stored or provided for the underlying data source.
Do I need an On-premises Data Gateway to connect SAP HANA Datasphere to Power BI Service?
If you are using a custom local ODBC driver that Power BI Service does not natively support in the cloud, you may need to install a Power BI On-premises Data Gateway (Standard mode) to bridge the secure connection and pass credentials between the cloud and your data source.
