Power Query connection issues RRS feed

  • Question

  • Hi

    I am using Excel as the reporting tool across the organisation whihc is connecting to SQL 2016 using power query. I can make the connection fine but i run into issues when publishing the report with the connection string as users arr having issues connecting back to SQL and updating the underlying data

    I have tried playing around with the settings for the connection but no mater what i try i can't get a consistent connection experience for the users. Sometimes it works other times it doesn't

    I have done this when we connecting to sql 2008 but since we have upgraded i just can't make this set up work. Is what i'm doing possible and can anyone point me to any resources to help me understand how i need to set this up


    Wednesday, October 9, 2019 7:06 AM