Forum Discussion
Getting error while data refresh
Hi Everyone
i am bringing data from api's in power bi and
when i publish report in power bi service , i get the following error
however dataset is getting refreshed properly in the desktop.
govind_021 Hey,
This is authentication issue due credential missing on power bi service.
steps are below
login to power Bi service portal
select your workspace
select your report dataset then followed by setting
Select data source credential
select oauth 2 authentication
once this is done then your report is succesfully authenticated.
or - follow below method for Long term solution
Go to Manage connection and Gateway
you will see New and get help on top left corner
select New - Gateway cluster name - Select your gateway name from Drop down
Connection name - combo of your server name + database name
then connection type - use SQL server (incase of SQL server)
database - add your data base name
use authentication
select basic authentication
add your id and password or use service account id and password
privacy - general
at last save
then you can use this connection in multiple report and this will work like a charm.
Thanks
Harish M
Did I answer your question? Mark my post as a solution! and Give Kudos as well
3 Replies
govind_021 Hey,
This is authentication issue due credential missing on power bi service.
steps are below
login to power Bi service portal
select your workspace
select your report dataset then followed by setting
Select data source credential
select oauth 2 authentication
once this is done then your report is succesfully authenticated.
or - follow below method for Long term solution
Go to Manage connection and Gateway
you will see New and get help on top left corner
select New - Gateway cluster name - Select your gateway name from Drop down
Connection name - combo of your server name + database name
then connection type - use SQL server (incase of SQL server)
database - add your data base name
use authentication
select basic authentication
add your id and password or use service account id and password
privacy - general
at last save
then you can use this connection in multiple report and this will work like a charm.
Thanks
Harish M
Did I answer your question? Mark my post as a solution! and Give Kudos as wellHi govind_021 It might be because the credentials are missing in Power BI Service please provide the credentials in PBI Service
Going to the dataset's settings in Power BI Service.
Re-entering credentials for all data sources under "Data source credentials."
Reactivating the scheduled refresh.
Hi govind_021 ,
Thanks for reaching out to the Microsoft Fabric Community forum.
- Navigate to your workspace where the dataset is located. Go to the dataset's settings page and re-enter the credentials for all data sources. check if any data sources require credentials. Make sure that the credentials are correct and have the necessary permissions.
-
select the appropriate authentication method (OAuth, Basic, Windows, etc.), and enter the credentials. If you see "Failed to test the connection", try switching the authentication method (e.g., from OAuth to Basic, if applicable).
- If the data source is in a gateway, confirm you have access to the data source in the gateway. If your data source requires an on-premises data gateway, ensure the gateway is installed, running, and correctly configured.
- Go to Manage Gateways in Power BI Service and verify if your data source is properly mapped.
- Sometimes, simply re-entering the credentials can resolve the issue. Remove the existing credentials and enter them again.
If you have tried all the above steps and are still facing issues, please share a screenshot of the error for more insigths.
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
- Navigate to your workspace where the dataset is located. Go to the dataset's settings page and re-enter the credentials for all data sources. check if any data sources require credentials. Make sure that the credentials are correct and have the necessary permissions.
