Forum Discussion

darmstrong0608's avatar
darmstrong0608
Regular Visitor
1 year ago

POWER BI ISSUE

HELLO,  THE ADMIN OF MY ACCOUNT WAS REMOVED AS THEY ARE NO LONGER WTIH THE COMPANY. WHEN THE REPORT GOES TO REFRESH, I GET AN ERROR MESSAGE STATING THAT THE ADMIN PASSWORD/INFO HAS CHANGED, AND AN A...
Need Help
darmstrong0608's avatar
darmstrong0608
Regular Visitor
1 year ago

I was receivng an error message for AUTH token needs to be refershed after the ADMIN on the account left my company, through some help here i was able to do a takeover and change this to my name, i was hopeful that would fix it but now i have a new error message . Now i have run into a new issue, it now shows this error. Any idea on how to fix? please keep in mind i have very limited knowledge base of this lol, the person who set this up is no longer with my company and i'm just trying to continue utilizing is at we were. no changes have been made to any files or anything, except for that person being removed, and i did the takeover. My error message changed from Autho token needs to be refreshed, to the below: 

Expression.Error: the key didn't match any rows in the table. The exception was raised by the IDBCOMMAND interface. 

 

  • sergej_og's avatar
    sergej_og
    Icon for Super User rankSuper User
    1 year ago

    Hey darmstrong0608 ,

    after taking over the ownership. What can you see in these sections?


    Are you able to use the gateway connections (within the Gateway section)?
    Are the credentials for your sources valid for you?

    Regards

    • darmstrong0608's avatar
      darmstrong0608
      Regular Visitor
      1 year ago

      Hello,

      when i go into gateway connections, it says that i don't need a gateway for this semantic model because it's data sources are in the cloud. 

       

      when i go to data source credentials, it shows sharepoint and edit credentials, as well as a show in lineage view option. the credentials for the sources are valid for me, when i clicked edit credentials, it says sharepoint data was saved. 

  • SaiTejaTalasila's avatar
    SaiTejaTalasila
    Icon for Super User rankSuper User
    1 year ago

    Hi darmstrong0608 ,

     

    Most of the time updating the credentials and authentication type to Oauth2 in datasource credentials will fix the issue.

     

    Thanks,

    Sai Teja 

    • darmstrong0608's avatar
      darmstrong0608
      Regular Visitor
      1 year ago

      i went into this setting, signed in and it said it was successful, but still not working. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi ,

    Based on the description, Where did you change the name? Try to create a new connection and select the credential. You can view the following document to learn more information.

    Connect to cloud data sources in the Power BI service - Power BI | Microsoft Learn

    Solved: Expression.Error: The key did not match any rows i... - Page 2 - Microsoft Fabric Community

     

    Best Regards,

    Wisdom Wu

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