Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

0
manjeshjk

Expression.Error: The key didn't match any rows in the table.

Submitted by Helper I on ‎09-01-2022 04:05 AM

Hi All,

 

I am getting the following error , Expression.Error: The key didn't match any rows in the table.

 
1) I added a table (RPA_GATEPASS) from my Oracle database and it accepts and got added to the data model.

manjeshjk_0-1662030104518.png

manjeshjk_1-1662030127741.png

 

2) When I try to add the complete string, since this is required for me to access the data through gateway

manjeshjk_2-1662030171107.png

manjeshjk_3-1662030188788.png

 

When I click the edit settings then this following dialog box appears and here I am not able to find the table name RPA_GATEPASS, somehow this view is not refreshed or it  is having some old snapshot. I cannot see many of the new tables that I created in the last couple of days ago.

 

manjeshjk_4-1662030228445.png

The power bi desktop version is
 
manjeshjk_5-1662030242605.png

 

 

Anybody facing issue like this, or any feedback/suggestions are welcome.
​
Regards,
Manjesh

 

Status: Delivered
See more ideas labeled with:
7 Comments (7 New)
Comments
Anonymous
Not applicable
‎09-01-2022 11:10 PM

Hi @manjeshjk 

You can find the table in Desktop , then you refresh your dataset in Service , the table is not exist ,right ?This issue caused by missing tables/views, either dropped or the user set in data source don't have access to. 

You can check the credentials in your data source in Service or chexk whether the table is in your data source .

 

Best Regards,
Community Support Team _ Ailsa Tao

manjeshjk
Helper I
Helper I
‎09-01-2022 11:14 PM

Hi @Anonymous 

The tables are existent I am able to load it from the oracle schema, however when I add the complete TNS string, somehow the tables are not shown. This is how we have built all our dashboards connecting to oracle database.

I can show a demo if necessary.

 

Regards,

Manjesh

manjeshjk
Helper I
Helper I
‎09-08-2022 02:15 AM

Hello @Anonymous ,

 

Good Day.

 

Any update.

 

Regards,

Manjesh

 

manjeshjk
Helper I
Helper I
‎09-15-2022 01:04 AM

Hello @Anonymous ,

Good Day.

Is there any update, appreciate your feedback on the same.

If you like to check out the out issue we can have a teams chat.

 

Regards,

Manjesh

Anonymous
Not applicable
‎09-19-2022 02:57 AM

Hi @manjeshjk 

Based on the limited availability of information on the forum, I suggest you open a support ticket .

The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

 

Best Regards,
Community Support Team _ Ailsa Tao

manjeshjk
Helper I
Helper I
‎09-19-2022 03:02 AM

@Anonymous ,

 

The issue got resolved after the upgrade of POWERBI desktop to September-2022 release. I have tested this morning and it works fine for me now. Thank you for the support. 

manjeshjk_0-1663581741875.png

 

Regards,

Manjesh

Anonymous
Not applicable
‎09-19-2022 06:18 PM

Hi @manjeshjk 

I am so glad to hear that your issue has been solved . I will change the status to "Delivered" .

 

Best Regards,
Community Support Team _ Ailsa Tao

Idea Statuses