Forum Discussion
Trouble with refresh : Unable to connect to data source undefined
I finally solved this problem!!! I did a research about SQL ERROR -213 and it is about query timeout. Then I set a time out option in my data source. ( [timeout=#duration(0,0,30,0)])), then the problem solved! But it took so long to refresh the dataset now.
-213 Statement interrupted by user. The database server received an interrupt signal from the user, probably because the user pressed the interrupt key (usually Delete or Control-C). The statement ended early. A program should roll back the current transaction and terminate gracefully. If the statement could modify a table, an interactive user should execute the ROLLBACK WORK statement to remove any partial modifications.
There was some known issues also going on, please refer the link.
If your issue is not in known issues list, please try to refresh the report from desktop and save the file with different name, publish and try to re-pro the issue.
Note:- Try to maintain the latest versions. (Power BI Desktop, On-premises Data Gateway).
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and give it some kudos?
I finally solved this problem!!! I did a research about SQL ERROR -213 and it is about query timeout. Then I set a time out option in my data source. ( [timeout=#duration(0,0,30,0)])), then the problem solved! But it took so long to refresh the dataset now.