Forum Discussion

becko1001's avatar
becko1001
Regular Visitor
3 years ago

Local Error with refreshing data from CSV located in SharePoint

Hi together,   I have a problem with updating my queries since yesterday.   When I click on Refresh in PBI Desktop I get the following error message: 'the underlying connection was closed - an u...
Need Help
pratyashasamal's avatar
pratyashasamal
Memorable Member
3 years ago

Hi becko1001 ,

Here are some methods you can try and find if they can help you solve your problem:

  1. Go to the data source credential of this dataset and update your credential to avoid credential problems.
  2. If the data refresh still fails, you can download the report which is linked to the dataset as pbix file and open it on Power BI desktop, then click Refresh in desktop to see which detailed error message display.
  3. Then try to solve the problem according to the error message. If you still have a problem, please show us your connection method to SharePoint online(web connector or SharePoint list or service). Have you done some data transform operation in power query(merge, append queries)

Here are some issues similar to your problem, you can check if it’s useful:

https://community.powerbi.com/t5/Service/Data-Refresh-Error-SharePoint-Request-failed/td-p/126791

Thanks ,
Pratyasha 
If you found this helpful please mark this as the solution .

  • becko1001's avatar
    becko1001
    Regular Visitor
    3 years ago

    Hi pratyashasamal ,

    thanks for your answer!

     

    However, the problem occurs exclusively in PBI Desktop.

    This eliminates methods 1 and 2 as possible solutions.

     

    The error only occurs when I update the query in PBI Desktop. In the service I can update the dataset without problems. Also, the identical PBIX file works for a colleague, for example. Therefore, it must be a local problem.

     

    I have several transformations in the query, however, I exclude them as a problem because 1.) it works at a colleague and 2.) there were no changes there.

     

    Do you have any other ideas?

     

    Thanks in advance!

    • pratyashasamal's avatar
      pratyashasamal
      Memorable Member
      3 years ago

      Hi becko1001 ,
      Please check the version of power bi that you are using .
      Please try to updated the version of power bi once .
      Thanks,
      Pratyasha

      • becko1001's avatar
        becko1001
        Regular Visitor
        3 years ago

        Hi,

         

        i'm already using Version 2.111.590.0. I think it's the newest one available?

         

        Best regards,

        becko1001