Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Unable to refresh data from Power BI Service

Hi Friends, I am new to power bi service. I am getting this message while refreshing the data. I have 3 datasources, MS Project Online, SharePoint On Premise and SQL DB On Premise. Dont know why I am getting this message while trying to refresh. Please help. Let me know what information is required from me to analyze this issue.

 

An error occurred while processing the data in the dataset.

Refresh failed:

Productivity from ( Workday MS Project Online SCSM )  has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Cds: Request failed: The underlying connection was closed: An unexpected error occurred on a receive."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Cds"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"https://xxxxxxxxxxxxx.crm4.dynamics.com/ "}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Projects.

Next refresh for Productivity from ( Workday MS Project Online SCSM ) is scheduled for September 3, 2021 2:30 UTC.

 

 

Learn more >

 

 

Technical Information

 

 

Activity Id:

9b40ec3a-af78-4cca-bd87-0e8a04b942f6

 

Request Id:

f9b21e61-f1a3-4f1d-8b76-01945e2f38b2

 

Cluster Name:

WABI-UK-SOUTH-redirect.analysis.windows.net

 

Refresh Start Time:

September 2, 2021 2:30 UTC

 

Refresh End Time:

September 2, 2021 3:03 UTC

Data Protection
Dataflow
Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous 

    I have a few questions to confirm .

    (1)Did you refresh successfully in Desktop ?

    (2)What do the data sources consist of the dataset that you refreshed ? MS Project Online, SharePoint On Premise and SQL DB On Premise are all in the dataset that you refreshed in Service ?

    (3)The gateway you used is standard gateway and is online ?

    (4) Did you successfully connect to the data source configured in the gateway ?

    (5)If your dataset contains all the data sources you mentioned , did you chose the parameter in gateway like the screenshot below ?

    When the data sources in your dataset come from local and cloud, check this parameter, it is unnecessary to add another cloud data source. Please refer to the following link for detailed operation .

    Merge or append on-premises and cloud data sources - Power BI | Microsoft Docs

    Please refer to my above questions for troubleshooting one by one .Looking forward to your reply .

     

    Best Regards

    Community Support Team _ Ailsa Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Alisa,

       

      Please find below my responses

       

      1)Did you refresh successfully in Desktop ? YES

      (2)What do the data sources consist of the dataset that you refreshed ? MS Project Online, SharePoint On Premise and SQL DB On Premise are all in the dataset that you refreshed in Service ? YES

       

      (3)The gateway you used is standard gateway and is online ? Personal gateway

      (4) Did you successfully connect to the data source configured in the gateway ? YES

       

      (5)If your dataset contains all the data sources you mentioned , did you chose the parameter in gateway like the screenshot below ? NO

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 

    Thanks for your reply .Now , please follow the steps below .

    (1)Install a standard gateway not a personal gateway ,because personal gateway just support Import mode not Direct Query mode .In your dataset , SQL DB is included .

    The link below is teach you how to install standard gateway .

    https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install

    You can also refer to the following link to compare the diff between personal gateway and standard gateway .

    https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode

    (2)When you install the gateway successfully , you need to go to Service to configure SQL DB datasource gateway .You can refer to the link below .

    https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-sql

    Notice : Due to the dataset is composed of cloud and local data sources , so when you configure gateway in Service ,you need choose the parameter that I mentioned before .

    (3)After you finish the datasource configuration , you need to go to Settings to connect the datasource with dataset .

    • For the on-premises source, select the gateway associated with this data source.
    • Under Data source credentials, edit the cloud data source credentials, as necessary.

    More info can refer to the link below .

    https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud

    (4) So far, the configuration is over, you can choose to manually refresh the data set, or you can choose to configure a scheduled refresh.

    https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

    Looking forward to your good news !

     

    Best Regards

    Community Support Team _ Ailsa Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 

    Can you refresh data from Power BI Service normally now ? If yes ,please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards

    Community Support Team _ Ailsa Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.