Refresh Data Error

[gembundy16]

Hi, 

I am trying to refresh my data, but it is showing it is blocked? Any ideas on how to fix this? FYI I'm new to Power Bi, its an incredible tool when I can drive it! 

[Syndicate_Admin]

There can be multiple credentials for a single data source, which is not supported in Power BI service. This error can occur, for example, when the data source is a cloud data source and multiple accounts are used to access the data source at the same time with different credentials. If the data source is on-premises, you must use the on-premises data gateway.

In case anyone stumbles upon this at any point, this is what solved the problem for me.

In a Dataset I added tables from a second schema that are in the SAME database. To access these schemas, a new user was created with permissions on these schemas.

The solution was finally to update the username (and password) in the Power BI service so that the gateway has the proper credentials.

[v-jingzhang · Accepted solution]

Hi @gembundy16 

Please scroll down the scroll bar and check whether there is any other query that has an error besides "Offsets By country" query. You can click on "Transform data" in Home ribbon to open Power Query Editor and review the error messages there. First check which queries have errors. Then search the possible solutions to correct each query one by one. 

For some common errors in Power Query, you can refer to the following documentation.

Dealing with errors - Power Query | Microsoft Docs

Common Authoring Issues in Power Query - Power Query | Microsoft Docs

In the second link, it has some possible reasons for "Error: The key didn't match any rows in the table" as below. Hope it helps. 

------------------------------------------------------------------

There are many reasons why Power Query may return an error that the key didn't match any rows in the table. When this error happens, the Mashup Engine is unable to find the table name it's searching for. Reasons why this error may happen include:

• The table name has been changed, for example in the data source itself.
• The account used to access the table doesn't have sufficient privileges to read the table.
• There may be multiple credentials for a single data source, which isn't supported in Power BI Service. This error may happen, for example, when the data source is a cloud data source and multiple accounts are being used to access the data source at the same time with different credentials. If the data source is on-premises, you'll need to use the on-premises data gateway.

------------------------------------------------------------------

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@gembundy16 , The last table is giving error, for that refer

https://blog.crossjoin.co.uk/2020/04/06/understanding-the-the-key-didnt-match-any-rows-in-the-table-...

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table...

https://community.powerbi.com/t5/Power-Query/Expression-Error-The-key-did-not-match-any-rows-in-the-...