Power BI report server schedule refresh error .

[Mahalaxmi]

When we perform schedule refresh in Power BI report seerver its failing with below error:

[0] -1055784932: Resource name and Location need to match. Resource name: SME LP DATE. Location: PolicyBased_36686F87_B3FA_4760_A613_9C6D47A37170.. The exception was raised by the IDbCommand interface.

We are using September 2021 PowerBI Desktop application and same version of server.

2022-07-12 14:13:02.1005|INFO|19|Catalog max connection pool size: 100

[v-luwang-msft · Accepted solution]

Hi @Mahalaxmi ,

Do you have consolidated queries in your reports? If so,consider disabling "fuzzy matching" when merging querries.

It appears that fuzzy matching is not compatible with refresh scheduling.

Disabling this feature will most probably result into fewer matches, so consider transforming your data/queries accordingly.

If you are using September 2021 PowerBI Desktop or September 2021 PowerBI Desktop for RS, please use the latter, here is the download link for the latter:

https://www.microsoft.com/en-us/download/details.aspx?id=57271 

And similar error refer:

https://community.powerbi.com/t5/Service/Data-Source-Error-Resource-name-and-Location-need-to-match/... 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien