Forum Discussion

tadeom0's avatar
tadeom0
Frequent Visitor
1 year ago
Solved

Data Source Error when refreshing data in Power BI Service

Hello, I'm getting this error when I tried to refresh my datasets in Power BI service. Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPi...
Need Help
Show and Tell
Tips and Tricks
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    Hi tadeom0,

    Thank you for your follow-up.


    To address the issue you're encountering, you can consider merging the tables directly in SQL Server instead of doing it in Power BI. This can be achieved by creating a new table in SQL Server that combines the data from both the SQL Server database and the Excel file. This approach can help avoid the refresh error in Power BI Service.

    If you need further assistance or have any more questions, feel free to ask. If this solution works for you, please mark it as accepted and give it a "Kudos" so other members can benefit from it.

    Thank you.

SaiTejaTalasila's avatar
SaiTejaTalasila
Super User
1 year ago

Hi tadeom0 ,

 

Go to semantic model settings>credentials -update your credentials>Oauth2 and organizational.If it is not working downloaded your report and turn on column quality in transform data and check your applied steps for any errors in the following table TechOpsPlanDataXSquadData.

 

Thanks,

Sai Teja 

  • tadeom0's avatar
    tadeom0
    Frequent Visitor
    1 year ago

    I already updated my credentials and also turned on column quality to check for any errors but there are no errors in each applied steps.