Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Refresh error on my dataset

Hello everyone, 

As I was testing a very simple R script to check if the refresh was working properly on my dataset, I came accross this error: 

 

These are the two data sources that I am using (R and SharePoint) and the credentials seem fine: 

 

 

 

 

 

 Any ideas on where the error is from ? We use an enterprise gateway so I don't think it is a gateway problem. 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    hi Anonymous - Can you please confirm if the R script is referring to a data file or source which is not hosted on Cloud? The screenshot is not too clear but from what I can interpret the connectivity is failing as it is trying to access a on-prem source but there is no Gateway setup.  

     

    If my response helped with your question please provide a 👍 and mark the post as a solution as this will help others in the community with a similar question. Thanks! 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      hi Anonymous ! the R script is referring to a data file that is on sharepoint (an excel file). It is just a simple table with two columns : i'm trying to add the columns together in a third column. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        hi Anonymous - Are you the owner of the published dataset? If yes, do you see the option of "Data Source Credentials" in the dataset properties? 

        You can try and re-enter the credentials for both your sources using the "Edit Credentials" option here - this should setup your credentials for refresh. 

         

        If my response helped with your question please provide a 👍 and mark the post as a solution as this will help others in the community with a similar question. Thanks!

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi, Anonymous 

     

    If you are using the data source of the R script/Python, then you can only use a personal gateway to refresh. 

    Reference: Use R in Power Query Editor - Power BI | Microsoft Docs

     

    Best Regards

    Janey Guo

     

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