POWER BI ISSUE

[darmstrong0608]

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 AUTH TOKEN NEEDS TO BE REFRESHED IN ORDER TO WORK. RIGHT NOW THE REPORT REFRESHES, BUT GIVES AN ERROR MESSAGE SO I'M UNABLE TO SEE THE UPDATED REPORT AS I TYPICALLY DO EACH DAY. CAN SOMEONE WALK ME THROGH IF POSSIBLE BEING ABLE TO FIX THIS? I AM NOT AN EXPERT AT THIS PROGRAM, IF THERE'S A WAY TO SIMPLY CHANGE THE NAME TO MINE AS I DO HAVE ACCESS OR ANOTHER WAY TO SIMPLY FIX, I WOULD GREATLY APPRECIATE ANY ASSISTANCE. THANKS! 

[darmstrong0608]

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. 

[v-jiewu-msft]

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.

[SaiTejaTalasila]

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]

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

[sergej_og]

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]

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. 

[lbendlin]

Go to the workspace, identify the semantic model for your report, and then click the big green "Take over"  button.

[darmstrong0608]

Hello,

I tried your method but do not have a takeover button to click when I go there. 

[lbendlin]

Can you show us what you see in the semantic model settings page (obscure any private information)

[collinq]

Hi @darmstrong0608 ,

As @lbendlin stated there should be a green "Take Over" button in the semantic model settings.  If that is not there , is the name for the owner of that model already you?  If you are the owner already, make sure that our userid is on the data source (look under the Data Gateway and Credentials section in the semantic model.

[darmstrong0608]

Thanks, i was able to find this after all and perform the takeover. 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. 

[SaiTejaTalasila]

Hi @darmstrong0608 ,

You can try to update the credentials in semantic model settings authentication method -Oath2.

If it's not working -

You can download the pbix file of that report and try to refresh the report on power bi desktop and see whether it refreshes or not.

I hope it will be helpful.

Thanks,

Sai Teja 

[lbendlin]

This article may help: Chris Webb's BI Blog: Understanding The “The key didn’t match any rows in the table” Error In Power ...