Connection Established but no Data in connection between SharePoint and Excel Powerquery RRS feed

  • Question

  • Hi There,

    I have established the connection with credential (A) between SharePoint and excel Power query but did not get data in the connection (0 item) . I have tried similar thing with another credential (B) and then all list is showing under connection (20 items). Both account (A and B) having full control permission on site (On-Prim). Even i tried with one test account (C) with design permission , it is also showing data (13 items).

    One more thing when i tried to connect QA site with credential  A (Full control) , it is working perfectly. On QA all credential A,B,C is working as per expected.

    I have used windows authentication in this.

    Please suggest why it is not working with Account A.


    Vikas Mishra

    Wednesday, June 22, 2016 5:02 PM