We have a workspace shared amongst several users. I have Publisher instaleld on a win 10 machine and built a set of reports using the conenctor 6 months ago. Whenever I open it i just hit refresh and everythnig works fine.
One of my colleagues can no longer refresh this same report as gets an error and a continuous loop to log in. I used a remote onto her pc and tried to make a new sheet wth a new connection using her login, the login of the admin user and my own loign. All failed with the same eroro "Can't access the dataset or the report". I then went to another PC I have which didnt have Publsiher installed. I installed the latest version and logged in as myself and got the same error.
So the old pc that has been refshing this report for months works fine and doesnt even ask me to loggin. My new pc wont connect. so i must have permission to access the dataset (I have double checked we are all still members).
Any one giot any idea why i can't make a new connection with a lgin that is clearly working elsewhere?
Thanks for any advice
Solved! Go to Solution.
So whne I treid this it asked me to install some files which i did and then whne excle opened I got this message which is the same error my colleage got when trying to refresh the existing model
"The follwoing system error occurred: (The operation completed successfully)"...which obviously it didn't!!!! It then asked me to sign in again and get the same error.
Can you send me a link to the older dll and where to install it please?
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!