Unable to refresh the SQL DB on Pwoer BI server and also the autorefresh is not working

[TatyDo]

Hallo Everyone,

I am facing with a problem when I publish the power BI on Web and try to refresh the DB.

The Gateway is set and the DB is working well on the Power BI Desktop where I can refresh it. The problem is only occurring when I publish eh DB and try to refresh it from the web. It is important since I wasn’t to share it and assign an auto refresh schedule.

Could you please help me there?

[v-easonf-msft]

Hi, @TatyDo 

Could you please tell me whether your problem has been solved?
Here is no content of description in the thread. If you still need help, please share more details to us.

You also can create a support ticket in Power BI Support to get further help.

https://powerbi.microsoft.com/en-us/support/ 

Best Regards,
Community Support Team _ Eason

[TatyDo · Accepted solution]

Thank you for your answer. Actually the problem has been solved. 

but I have used a different method as it was suggested although all of them were helpful. 

However, thank you for pointing out that I can creat a support ticket. That is something to use in the future. 

[v-easonf-msft]

Hi , @TatyDo 

There are many possible reasons for this error message“The key didn‘t match any rows in the table”.

First please confirmed that you service account running the gateway have read access.

Then make sure  the data source credentials are correct. 

You also need to check the table name and table structure in the SQLDB have not been changed.Even the little difference in capitalization may cause similar errors.

Related thread:

https://community.powerbi.com/t5/Desktop/Gateway-refresh-error-The-key-didn-t-match-any-rows-in-the-...

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

http://dataap.org/blog/2020/05/04/solved-power-bi-dataset-refresh-error-the-key-didnt-match-any-rows... 

Best Regards,
Community Support Team _ Eason

[Nimai123]

Hello @TatyDo 

I have faced this same issue a few weeks back.

You can try doing this hope it helps!

• Update the Gateway.
• Re-configure the Gateway. (Check the mappings)
• Do not run many refreshes at the same time because then the load increases on the SQL server.
• Raise a support ticket which is free if you are a PRO user, they will help you to get the logs and help you to understand the source of error so that we can work on the right direction. 

If you like my solution give it a Kudos!

And if it solves your problem accept it as a solution.

Regards,

[Greg_Deckler]

@TatyDo You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[amitchandak]

@TatyDo , seem like an issue with Gateway

refer

Troubleshoot gateway
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/
https://www.youtube.com/watch?v=mGnNn6gnrKk

else log an issue -https://community.powerbi.com/t5/Issues/idb-p/Issues